![]() ![]() SELECT dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.Caption0 AS ,ĭbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS, arp.DisplayName0,ĬASE WHEN arp.version0 LIKE '.0' THEN 'SP1' WHEN arp.version0 LIKE '.0' THEN 'SP2' WHEN arp.version0 LIKE '.0'Īrp.version0 LIKE '.1000' THEN 'SP1' WHEN arp.version0 LIKE '.1000' THEN 'SP2' WHEN arp.version0 LIKE '.1000'įROM dbo.v_Add_Remove_Programs AS arp INNER JOINĭbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID INNER JOINĭbo.v_RA_System_SMSInstalledSites AS ASSG ON dbo.v_R_System.ResourceID = ASSG.ResourceID INNER JOINĭbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |