Month – October 2011

Simple History query

Select distinct SD.Name0 ‘Machine Name’, HARP.DisplayName0 as ’32bit’, HARP.Version0, HARP64.DisplayName0 as ’64bit’, HARP64.Version0, SD.User_Name0 ‘User Name’ From v_R_System SD Join v_FullCollectionMembership FCM on SD.ResourceID = FCM.ResourceID Join v_Collection COL on FCM.CollectionID = COL.CollectionID left outer join dbo.v_HS_ADD_REMOVE_PROGRAMS HARP on SD.ResourceID = HARP.ResourceID left outer join dbo.v_HS_ADD_REMOVE_PROGRAMS_64 HARP64 on SD.ResourceID = HARP64.ResourceID Where COL.Name = ‘All […]

Two Software Titles

SELECT DISTINCT a.Netbios_Name0 AS ‘Computer Name’, CASE WHEN ARP.OMSA IS NULL THEN ‘N/A’ ELSE ARP.OMSA END AS ‘Dell OMSA Version’, CASE WHEN ARP.Equallogic IS NULL THEN ‘N/A’ ELSE ARP.Equallogic END AS ‘Broadcom Version’ FROM v_R_System_Valid a INNER JOIN v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = a.ResourceID INNER JOIN v_FullCollectionMembership FCM on FCM.ResourceID = a.ResourceID –INSTALLED SOFTWARE– LEFT […]

This is a test of the a code plug-in for live writer.

SELECT A.AdvertisementName, A.ProgramName, R.Netbios_Name0 as Computername, SCUM.TopConsoleUser0 as MainUsername FROM dbo.v_R_System_Valid R join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R.ResourceID = SCUM.ResourceID join dbo.v_ClientAdvertisementStatus CAS on R.ResourceID = CAS.ResourceID join dbo.v_Advertisement A on A.AdvertisementID = CAS.AdvertisementID .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { […]

Advertisements, Programs and Main User of all PC

SELECT A .AdvertisementName, A .ProgramName, R .Netbios_Name0 as Computername, SCUM .TopConsoleUser0 as MainUsername FROM dbo .v_R_System_Valid R join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R.ResourceID = SCUM.ResourceID join dbo.v_ClientAdvertisementStatus CAS on R.ResourceID = CAS.ResourceID join dbo.v_Advertisement A on A.AdvertisementID = CAS.AdvertisementID