Asset Management Suite

 View Only
Back to Library

Overview of resource associations 

May 26, 2015 06:43 PM

I am often busy creating custom reports on asset and inventory data in plain T-SQL. Each time I want to join a resource to a different resource I have to lookup the ResourceAssociationTypeGuid. (eg. inner join ResourceAssociation on ResourceAssociation.ParentResourceGuid = Resource.Guid And ResourceAssociationTypeGuid = 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
I could not find an overview in the knowledgebase or here on connect. Therefore I decided to run a query to obtain the information of the different resource associations. The output is listed below. The GUIDs are common between different installations.
It's a bit quicker to just grab the GUID from this list instead of having to manoeuvre through the console or run another query to obtain the GUID once again.

Guid ResourceAssociation ParentResource Child
{4582ADBC-43FA-4783-807A-A3CD7D58992C} Account Credential Account Credential
{1466E770-4413-4517-A89D-6599B8A7F144} Asset Department Owners Asset Department
{ED35A8D1-BF60-4771-9DDE-092C146C485A} Asset User Owners Asset User
{94CEC4BF-0659-4291-84F0-E7EDCC95810C} Assets' Associated Catalog Item Asset Fixed asset catalog item
{3028166F-C0D6-41D8-9CB7-F64852E0FD01} Asset's Status Asset Fixed Asset Status Resource Type
{383CE8F3-458B-4240-86D5-1FFE7E96D40B} Associated Assets Asset Asset
{A142B447-BEFF-434D-BD02-577636E2C644} Bay Computer Computer Physical Bay
{AACD5011-2D6A-4AC0-B4DE-7D79B442EB8E} Book Depreciation Software Purchase Depreciation Schedule
{25292C7A-A3EA-48ED-9681-39B67D1358C8} Book Depreciation Asset Depreciation Schedule
{1498FC81-02B4-42B9-9925-1417441B45C6} Business Owner Services User
{90879BB6-EF1C-4FD0-A8F7-4E68B92B9537} Catalog for Catalog Entry Catalog Entry Catalog
{97D3522D-0D2E-4DCE-9014-E8E4712D59DE} Catalog To Supplier Catalog Company
{55697D45-FE80-4475-91A0-F3CC450B012C} Change Owner Services User
{9CA42AC0-1FB7-4ED8-8D44-D51668D4436A} Check Stockroom Purchase Request Stockroom
{47096C87-ABC9-406D-BEE3-5C8381B9349E} Cluster Contains Computer Cluster Computer
{64727DE8-29BD-4529-8622-BD0DD92E4258} Command Line Requires Package Software Package Software Command Line
{D784AE31-3963-4009-AC43-2F547ED038AE} Computer Hosts Virtual Machines Computer Virtual Machine
{5E8E3C61-A80C-4B0A-A228-DBF97607CEE4} Computer To Site Computer Site
{74C9AD4A-E384-477E-BD06-132A3368E58D} Computer Type Computer Computer Type
{494B8115-FE35-41C8-AA8F-AB267B778CE4} Computer's Print Queues Computer Print Queue
{E58BA278-A69A-4C65-8D20-BE5771FB1CF1} Contract's Assigned User Contract User
{989AF046-7279-43C6-9C63-B2CEEA631AE9} Contract's Location Contract Location
{9BC22D17-C0CF-45D5-9A8F-D62BBAFD955D} Cost Center Asset Cost Center
{338A1ECF-983D-49A9-B19E-FAE972AC1A3F} Cost Center (Software Purchase) Software Purchase Cost Center
{9E0711FC-6869-4E4A-B469-6C7055941803} Cost Center Hierarchy Cost Center Cost Center
{BB7A5AD9-B6A9-4320-8203-DFA691DD5AB2} Cost Center's Location Cost Center Location
{65D9B2E7-9AC9-4563-9225-8B46E1E0AEFE} Cost Center's Manager Cost Center User
{59C323AA-E616-489A-BD30-A671F4F6C8C8} Covered Software Product Software License Software Product
{A2E422F0-D944-47E5-A48A-0E49A923902B} Credential Authentication Server Credential Authentication Server
{FE6BA454-67FE-44B9-8A19-0081E262FE9F} Custom Depreciation Software Purchase Depreciation Schedule
{6224B5D8-6E87-4D5D-B3C0-697C00D5208C} Custom Depreciation Asset Depreciation Schedule
{36E6C096-14A9-4E8D-A5E7-D6C68C362AC6} Default Package Policy Resource Inventory Rule
{6D5E9C6E-71FF-4F76-8AB2-662E531F219F} Department Hierarchy Department Department
{9103F1E4-2E4B-4E82-B039-3FFFACA0542B} Department's Cost Center Department Cost Center
{9E4CED04-C03F-473C-B0C3-1C1D1B8DF49B} Department's Location Department Location
{80EC2411-9F8B-43D6-BBCF-CF730B771E1A} Department's Manager Department User
{30D1A76B-2FC7-4181-9F86-A0CF9CE14FD8} Dependent CIs Services Asset
{EB95349E-2BC1-4EC0-BAA5-169987CCF469} Enclosure Bay Physical Enclosure Physical Bay
{83311B0E-5C47-44D7-9469-66720CBEB041} Installed Location Software Purchase Location
{D82F7529-3554-4547-9862-16455762F31C} Internal Credential Password Policy Internal Credential Password Policy
{0ACC4608-FF0C-4575-91DA-C980259441B6} IT Owner Services User
{05DE450F-39EA-4AAE-8C5F-77817889C27C} Location Asset Location
{DC4689D9-1D2D-47CC-BF65-FD9437D08ED5} Location Hierarchy Location Location
{A77EA2E1-00C6-42A3-8501-637405DDFF5F} Location To Subnet Location Subnet
{480838DA-E33E-4361-97A3-60166C1DE52E} Location's Cost Center Location Cost Center
{CAC9EA4C-AF5E-4C9E-BB62-67DED2CEA546} Location's Manager Location User
{A2FDFA5F-D401-4525-BE71-C900B4BEB755} Manager Project User
{A9C3BE17-21E5-4329-A2E4-833DE97CACA0} Master Lease's Lease Schedules Master Lease Lease Schedule
{1EDA7E8D-3F2A-4C76-BC32-F325C97AC14D} Master License's Software Licenses Master License Agreement Software License
{22F49A82-F06E-405B-B66C-A434AEB9C1DF} Modular Chassis Contains Asset Modular Chassis Asset
{B132DB3C-7600-44BF-91FF-B291016723FC} New Software License (if renewed/upgraded) Software License Software License
{E46BFCE4-A041-4245-ADD2-98A93459DAE3} OOB Management Device Manages Computers OOB Management Device Computer
{3979F09B-D56D-4DA8-834B-4E06DF92AAF6} Parent to Child Software Channel Software Channel Software Channel
{0BD04422-3589-4DB2-A6B4-78D5D5661270} Power to Network Resource Power Network Resource
{1183C115-68DE-4E58-8DF5-F23EBE8EC8A3} Power to UPS Power UPS
{89C49101-A1CD-41A1-BADC-78FAE18A6899} Print Queue's Printer Print Queue Network Printer
{4C07CC91-CF94-4766-8969-CA9F64959AD2} Rack Enclosure Physical Rack Physical Enclosure
{3E564144-F664-433A-B5B2-DD25959C4BC7} Receive To Stockroom Purchase Order Stockroom
{7AA85B62-D9BA-40CF-9E96-C186B1849A03} Received Asset's Location Receive Items Page Parameters Location
{841B8F63-8401-44EF-BCC4-45E44CF2612F} Received Asset's Status Receive Items Page Parameters Fixed Asset Status Resource Type
{FD0A2540-C373-45C9-95C8-4E8177BF295B} Requestor Purchase Request User
{D528BCE5-8911-4762-90D9-72CA0AB87D86} Resource Is Applicable Resource Inventory Rule
{6CCB60F8-E88D-4BA2-959F-4B531C8C5FCD} Resource Is Installed Resource Inventory Rule
{80031FD0-3C5A-4E14-A2CD-A3F77EA11D26} Resource Is Upgradable Resource Inventory Rule
{63468F04-6751-448D-891C-B59906360A27} Role Trustee Role Trustee
{223C10E6-D635-4F80-AA3C-309DF3A7DD3C} Service Pack Applies To Software Release Service Pack Software Release
{5F00E96B-93F3-41F0-94A7-7DBBB8AEF841} Site Service To Computer SiteService Computer
{F71ABA8C-8823-44C8-A750-F03DE84DC5F6} Site To Subnet Site Subnet
{046E5388-2D47-4383-86B9-9156E0257F3D} SLA Services Service Level Agreement
{7EEAB03A-839C-458D-9AF2-55DB6B173293} Software Bulletin To Software Update Software Bulletin Patch Software Update
{2FFEB9F0-601E-4746-A830-BDB200076503} Software Bulletin To Vendor Software Bulletin Company
{85B128D2-4341-48C9-B1CC-13F570188055} Software Channel Targets Software Release Software Channel Software Release
{F35C6627-F70C-44A0-AFB8-490CE4D3ECAF} Software Component Applies To Locale Software Component Culture
{48236D29-02FA-4AB4-95D5-66255D457490} Software Component Applies To Operating System Software Component Operating System
{FCE06C55-AB2D-4849-A5EF-77EB7CDD217E} Software Component Applies To Software Platform Software Component Software Platform
{644BA107-E0B0-41C1-9171-8BCFAC9A390A} Software Component Conflicts With Software Component Software Component Software Component
{EABE86D3-AAFD-487A-AF63-5C95D7511AF6} Software Component Contains File Software Component File
{194709B5-8EA2-4594-A0CD-CBEBC2A07551} Software Component Contains Software Component Software Component Software Component
{920F1D74-8FCF-4553-9208-4AE2882D4315} Software Component Depends on Software Component Software Component Software Component
{644A995E-211A-4D94-AA8A-788413B7BE5D} Software Component Supersedes Software Component Software Component Software Component
{292DBD81-1526-423A-AE6D-F44EB46C5B16} Software Component To Company Software Component Company
{4D33D29B-DC9F-4E72-9A80-C5FB7CEC0FB6} Software Installation File to Software Installation Type Software Installation File Software Installation Type
{C5A960A2-BCA2-410A-AABF-D3FC9A29B7CE} Software Package Contains File Software Package File
{34F2B0FE-E63E-4B8E-B359-FF73A026FE51} Software Package Contains Software Installation File Software Package Software Installation File
{4486DFB2-D504-4493-B5B0-DF950352AB05} Software Package Installs Software Component Software Package Software Component
{9D67B0C6-BEFF-4FCD-86C1-4A40028FE483} Software Product Contains Software Component Software Product Software Component
{AE4DBDF7-457B-4828-A83E-B64B91AE0E87} Software Product Is Of Software Type Software Product Software Type
{D5C66D5A-7686-4CA2-B7C1-AC980576CE1D} Software Product to Company Software Product Company
{2D12146F-8AA9-4A41-B7DB-577892EF8692} Software Program Installs Software Component Software Command Line Software Component
{0DA075AC-6FCA-411C-AEEC-AE1003FA93E6} Software Purchase Department Software Purchase Department
{5CF17724-8F75-4505-8898-7B42D8CD62DA} Software Purchase User Software Purchase User
{F7002A49-11A6-44EA-AF19-2E06632FF831} Software Purchases Software License Software Purchase
{16B5F8AA-EC3B-470B-8D2B-CC7E0A060E71} Software Purchases' Associated Catalog Item Software Purchase Software catalog item
{49531613-2D91-4F73-9439-C5EF116F4D00} Software Update Applies To Service Pack Patch Software Update Service Pack
{9603714F-078D-4B85-989D-81FC23ABF397} Software Update Applies To Software Release Software Update Software Release
{A19CED33-9E1F-4E97-98CF-0F8B339739C3} Software Update Created Software Package Patch Software Update Software Package
{47203E4C-D584-4E0A-B8C3-0C0D8AED8B63} Software Update Return Code To Software Installation Type Software Update Execution Code Software Installation Type
{EFD2A275-2E31-4C34-8457-0CADD40A3C35} Stockroom Manager Stockroom User
{EAD0BD83-5458-43AD-80F4-4586E3DA5215} Stockroom's Location Stockroom Location
{ED358164-48FF-45C7-BBBD-F12B5DD3F64B} Supporting Systems Services Systems
{5E96652A-C442-4E43-93D2-A813599BAC2B} Systems Systems Asset
{D514C76F-B2AF-4982-B280-C6EC72DA2C46} Tax Depreciation Asset Depreciation Schedule
{DA0B990F-4F19-4FC9-B131-8162E8D72A65} Tax Depreciation Software Purchase Depreciation Schedule
{E49E23A6-6AD9-4859-ADEB-DEA814C74F4A} UPS to Network Resource UPS Network Resource
{4E107C3E-2B2E-4F47-A5D8-06AECADA1893} User's Company User Company
{D9656701-B8EE-48C1-A4E3-5741CA18471D} User's Department User Department
{7AE2308D-84FC-41E9-AAF9-8E2C6BE51735} User's Direct Reports User User
{2030C6CD-C049-4C81-957D-34E4DFB23BCF} User's Location User Location
{049C633F-8413-42AE-93EA-F4EB7EDAFC65} User's Manager User User
{EEDF0A0E-707E-4E0E-A31F-04EF01BA7C14} Virtual License's Software Licenses Virtual License Agreement Software License
{3AABC28B-2798-415B-893B-931DCF647414} Virtual Manager Manages Virtual Hosts Asset Computer
{5DA45094-A97F-401B-84BF-5ED68923EDC0} VSA Provides Virtual Software Layer VSA or XPF Software Installation File Virtual Software Layer

The query I used to build this list can be found at http://www.symantec.com/connect/blogs/understanding-resourceassociation-table

Statistics
0 Favorited
6 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

zwin
Jun 27, 2018 04:23 PM

Hello,

I know this is an old post and i'll be askign a really new question.  I'm not too experiened with SQL and just starting to try and get a handle on using it to pull reprots from Altiris.  Yours is the only post i've foudn so far that looks like it's cracked the issue i'm having.  I'm trying to make a querry that will let me associate the software name with the software type.  From what i can see, it's related this this line:

{AE4DBDF7-457B-4828-A83E-B64B91AE0E87} Software Product Is Of Software Type Software Product Software Type

What i'm confused about is how to fill that into the INNER JOIN statment.  I beleive the relevant views i'm looking for are vSoftwareProduct and vSoftwareType, but i'm not even sure of that.  Is there any chance you could show me a sample how how to do that specific join?

Thanks!

Related Entries and Links

No Related Resource entered.