IT Management Suite

Hi everyone; I feel odd asking for help in this, but I have no experience with report creation in Altiris. I also don't have any experience in SQL. My main inquiry is; I have an "all computers" that I need to add a colum that would show the version of Office installed. Not sure what I can and can't post but I have the code for the report if need. I'd appreciate any help. Thanks.

Microsoft office installation report with Version
https://www.symantec.com/connect/forums/microsoft-office-installation-report-version

report of ms office
https://www.symantec.com/connect/forums/report-ms-office

Hi Mr. Pauly.

I'm attaching bellow an example that you can use and customize your own report.

SELECT

vc.Name as 'Computer'
,vc.[User]
,vc.[OS Name]
,vc.[System Type]
,iadd.DisplayName as 'Software'
,iadd.DisplayVersion as 'Version'

FROM vComputer vc

LEFT JOIN Inv_AddRemoveProgram iadd ON iadd._ResourceGuid = vc.Guid

WHERE
    vc.IsManaged = 1
    AND iadd.DisplayName LIKE 'Microsoft Office Professional%'
    AND iadd.InstallFlag = 1
    
ORDER BY vc.Name

Thanks Alex and Fernando. I will try this shortly and post an update.

Fernando that worked excellently!! I want to let you know how grateful I am for your help, this couldn't have come at a better time!!

I had to create a brand new report, because my current one would not work with that you sent. In the new report I was able to add the value for IP address and OS version type. I keep getting an error when adding location. I'm adding what the code looks like now:

SELECT

vc.Name as 'Computer'
,vc.[User]
,vc.[OS Name]
,vc.[System Type]
,vc.[IP Address]
,vc.[System Type]

VL.Location
,iadd.DisplayName as 'Software'
,iadd.DisplayVersion as 'Version'

FROM vComputer vc

LEFT JOIN Inv_AddRemoveProgram iadd ON iadd._ResourceGuid = vc.Guid

WHERE
    vc.IsManaged = 1
    AND iadd.DisplayName LIKE 'Microsoft Office%'
    AND iadd.InstallFlag = 1
    
ORDER BY vc.Name

the item in bold keeps causing an error when I add it to your code. Is there anything I can do to get the location on that report? Thanks again for your help, like I said before, you could not have come at a better time to help me with this!

-Paul

You need a JOIN to add the Asset's Location, if it has been set in the SMP. This uses a Resource Association and can be set when you Edit a Computer, scroll down to Location.

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

Got it!! Thanks Alex!!

That did the trick! Thanks a million! \0/