Asset Management Suite

 View Only

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

    Posted Sep 24, 2009 06:37 PM

    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



  • 2.  RE: Need to bring in the Cost Center Manager field into a report

    Posted Sep 25, 2009 10:43 AM
     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