Elsasoft Forums
Elsasoft Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SqlSpec
 Tips and Tricks
 Adding fields to output?
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

moperry
Starting Member

2 Posts

Posted - Jan 20 2014 :  09:43:08 AM  Show Profile  Reply with Quote
Hello,

Wondering if there is a way to add information to the output. For instance, in the table information, I would like to add Last Updated, Last Accessed, and other information usually found in sys.dm_db_index_usage_stats in SQL Server.

If adding fields to the output is possible, could I get a generic example and instructions how to add?

Thanks much.

Jesse
Forum Admin

732 Posts

Posted - Jan 21 2014 :  10:23:33 AM  Show Profile  Reply with Quote
You can add fields, but not the ones you want. The reason is for the added fields, the values are taken from extended properties, not from the DMVs.

There is detail on this here: http://www.elsasoft.com/sqlspec.htm#_Toc335682102
Go to Top of Page

moperry
Starting Member

2 Posts

Posted - Jan 22 2014 :  07:44:49 AM  Show Profile  Reply with Quote
quote:
Originally posted by Jesse

You can add fields, but not the ones you want. The reason is for the added fields, the values are taken from extended properties, not from the DMVs.

There is detail on this here: http://www.elsasoft.com/sqlspec.htm#_Toc335682102



Ok. That makes sense. I assume I could set the value of last updated in the extended property field in SQL then code for it in the XML project file.

Yes?
Go to Top of Page

Jesse
Forum Admin

732 Posts

Posted - Jan 22 2014 :  10:25:19 AM  Show Profile  Reply with Quote
yes that would work. However then it would be up to you to keep the value of the extended property in sync with reality.
Go to Top of Page

BerythaBeasley
Starting Member

1 Posts

Posted - May 30 2018 :  01:39:23 AM  Show Profile  Reply with Quote
Hi Wondering if there is a way to add information to the output. For instance, in the table information, I would like to add Last Updated, Last Accessed, https://arynews.tv/en/category/pakistan-elections-2018/and other information usually found in sys.dm_db_index_usage_stats in SQL Server... If adding fields to the output is possible, could I get a generic example and instructions how to add?

Thanks much.

Beasley

Edited by - BerythaBeasley on Jun 02 2018 01:37:29 AM
Go to Top of Page

scotmaria
Starting Member

1 Posts

Posted - Jun 21 2018 :  03:34:05 AM  Show Profile  Reply with Quote
I assume I could set the value of last updated in the extended property field in SQL then code for it in the XML project file.http://www.hghgenf20plus.com/how-hgh-supplements-work/



[url=http://www.hghgenf20plus.com/]genf20 plus[/url]
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Elsasoft Forums © Elsasoft LLC Go To Top Of Page
Snitz Forums 2000