Servers Report Query

SELECT    
    R.Netbios_Name0,
    os.Caption0,
    ARP.DisplayName0 As ‘Softwarename’,
    ARP.Publisher0 as ‘Publisher’,
    ARP.Version0 as ‘version’,
    ARP.ProdID0 as ‘productID’,
    ARP.InstallDate0 ‘InstallDate’,
    R.AD_Site_Name0 as ‘ADSite’,
    R.User_Name0 as ‘Last Logged on User’,
    R.Operating_System_Name_and0 as ‘OS’
FROM        
    dbo.v_R_System R
    inner JOIN dbo.v_Add_Remove_Programs ARP ON R.ResourceID = ARP.ResourceID
    inner join dbo.v_GS_OPERATING_SYSTEM OS on R.ResourceID = OS.ResourceID
Where
    R.Operating_System_Name_and0 like ‘%NT%Server%’
Order by
    R.Netbios_Name0,
    ARP.DisplayName0

Leave a Reply

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