Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Need to bring in the Cost Center Manager field into a report

Updated: 22 May 2010 | 1 comment
J Steinert's picture
0 0 Votes
Login to vote

Does anyone know which table is hiding the 'Cost Center Manager' information?  I have been browsing the asset tables and views, but I haven't found anything that resembles the Manager as it relates to the Cost Center.  Any ideas?

Thanks,

Jason

Comments

mgreen's picture
25
Sep
2009
0 Votes 0
Login to vote

Resource Association

 This will be in the dbo.resourceassociation table.  Use this Altiris KB for an example query that joins the item table so you can see the name of each parent and child association.  The query in this KB also works for CMDB 7.

https://kb.altiris.com/article.asp?article=29384&p=1

Regards, Matt Green Senior Systems Engineer Intuitive Technology Group www.be-intuitive.com