Adding “SMS Scanned Date” to a software inventory report

SELECT DISTINCT
CS.Name0,
CS.UserName0,
ARP.DisplayName0,
WS.LastHWScan
FROM
dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_WORKSTATION_STATUS WS
WHERE
ARP.ResourceID = CS.ResourceID
AND CS.ResourceID = WS.ResourceID
AND (ARP.DisplayName0 Like ‘%microsoft%office%pro%’
  OR ARP.DisplayName0 Like ‘%microsoft%office%stan%’)
  And (ARP.DisplayName0 Not Like ‘%visio%’
  And ARP.DisplayName0 Not Like ‘%Proof%’
  And ARP.DisplayName0 Not Like ‘%Project%’)

Leave a Reply

Your email address will not be published. Required fields are marked *