Client Management Suite

I have updated all of our locations under asset managment but wondering now if I run a report that is looking for all of the installs of Office 2010 is there a field I can add that pulls those locations of the devices it finds it on?

I'm away from an NS at the moment to confirm but I'm sure these Reports exist, if not you could clone a current report and just amend the sql to include a resource association of location to machine and filter by the product. ITMS 7.1 - Installed Software Reports (Optimized) https://www.symantec.com/connect/downloads/itms-71-installed-software-reports-optimized Reports->Discovery and Inventory->Inventory->Cross-platform->Software/Applications->Software Installed Software Installed Software by Computer

That pretty much what I'm doing I just don't know what resource to use that pulls in the location

Below are the current options I have the report pulling, would think there would be on that just does location since that info is attached to the device is you right click on it

 

Cody

Have you had a chance to review this KB article?

How to create a custom report or a SQL script that can reference asset associations, such as Status, Asset Owner, Location or Department

https://support.symantec.com/en_US/article.HOWTO85139.html

Thanks didn't see that one, I'm terrible when it comes to sql and was opening it was just a simple table to add but will start with that KB and see what I can create.
 

Ok so I found what needs to be ran from one of Alex's old posts under another section:

 

SELECT  
  ri.[Guid] AS [AssetGuid],   
  ri.[Name] AS [AssetName],
  l.[Guid] AS [LocationGuid],
  l.[Name] AS [LocationName]
FROM  
  vRM_Asset_Item ri  
  INNER JOIN ResourceAssociation ra
    ON ri.Guid = ra.ParentResourceGuid
    AND (ra.ResourceAssociationTypeGuid = '05de450f-39ea-4aae-8c5f-77817889c27c') --Location
  INNER JOIN vRM_Location_Item l
    ON ra.ChildResourceGuid = l.Guid

That atleast gives me a report that tells me device name and the location, now I just need to figure out how to add this into my office 2010 report.

 

Here is one report I would like to add this location info into, anyone have tips on how I combine the above one into this:

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name] AS [Computer],
   [dca3_AeX AC TCPIP].[IP Address],
   [dca4_AeX AC Identification].[OS Name],
   [dca5_OS Operating System].[OS Architecture],
   [dca9_Agent Plugin Inventory].[ManufacturerName],
   [dca9_Agent Plugin Inventory].[ProductName],
   [dca9_Agent Plugin Inventory].[SerialNumber],
   [dca7_HW Computer System].[Total Physical Memory (Bytes)],
   [dca8_SW BIOS Element].[Release Date],
   [dca10_Client Task Resources].[LastRegistered],
   [dca6_AeX AC Primary User].[User],
   [dca4_AeX AC Identification].[Last Logon User]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca3_AeX AC TCPIP]
         ON ([vri2_Computer].[Guid] = [dca3_AeX AC TCPIP].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_OS_Operating_System] AS [dca5_OS Operating System]
         ON ([vri2_Computer].[Guid] = [dca5_OS Operating System].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca6_AeX AC Primary User]
         ON ([vri2_Computer].[Guid] = [dca6_AeX AC Primary User].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_HW_Computer_System] AS [dca7_HW Computer System]
         ON ([vri2_Computer].[Guid] = [dca7_HW Computer System].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_SW_BIOS_Element] AS [dca8_SW BIOS Element]
         ON ([vri2_Computer].[Guid] = [dca8_SW BIOS Element].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_Agent_Plugin_Inventory] AS [dca9_Agent Plugin Inventory]
         ON ([vri2_Computer].[Guid] = [dca9_Agent Plugin Inventory].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_Client_Task_Resources] AS [dca10_Client Task Resources]
         ON ([vri2_Computer].[Guid] = [dca10_Client Task Resources].[_ResourceGuid])
WHERE
   (
      (
         (
            ([vri2_Computer].[IsManaged] = 1)
            AND
            ([vri2_Computer].[ResourceItemDeleted] = 0)
         )
         AND
         (
            ([dca4_AeX AC Identification].[OS Name] LIKE N'%Windows 7%')
            OR
            ([dca4_AeX AC Identification].[OS Name] LIKE N'%Windows 7%')
         )
      )
      AND
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
ORDER BY
   [Computer] ASC