|
Browse by Tags
All Tags » Code ( RSS)
-
|
select Distinct CS.Name0 from dbo.v_GS_COMPUTER_SYSTEM CS left outer join dbo.v_GS_SoftwareFile SF on CS.ResourceID = SF.ResourceID where SF.ResourceID not in (select Distinct...
|
-
|
select * from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where ...
|
-
|
select * from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR where IPAddress0 IS not NULL and IPAddress0 like '192.168.[1-9].%'
|
-
|
SELECT DISTINCT SYS.Netbios_Name0, fcm.SiteCode, ROUND(CONVERT (FLOAT ,LDISK.FreeSpace0) / 1024, 2) AS FreeSpace0, ROUND (CONVERT (FLOAT, PROC1.MaxClockSpeed0), -2)/ 1000 AS 'Processor...
|
-
|
I have decided that the forums on www.SMSUG.ca are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the...
|
-
|
select C.Collectionid, C.Name from dbo.v_Collection C Where C.Collectionid not in (Select Collectionid from dbo.v_FullCollectionMembership)
|
-
|
SELECT [AdvertisementID] ,[AdvertisementName] ,[ProgramFlags] ,[PackageID] ,[ProgramName] ,[CollectionID] ...
|
-
|
Select distinct TopConsoleUser0 from dbo.v_Add_Remove_Programs ARP Join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on ARP.ResourceId = SCUM.ResourceID Where ARP.DisplayName0...
|
-
|
Here is a nice and simple way to get a list of Random PCs. Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID...
|
-
|
select SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath From v_GS_SoftwareFile SF join v_R_System SYS on SYS.ResourceID = SF.ResourceID Where SF.FileName = 'OUTLOOK.EXE' AND FILEPATH...
|
-
|
Select CS.Name0, OS.Caption0, OS.CSDversion0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID Where OS.Caption0 like '%Vista%' and OS.CSDversion0 is Null
|
-
|
SELECT R.AD_Site_Name0, Count(SMS_Installed_Sites0) AS 'Count' From v_R_System R JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID WHERE ...
|
-
|
SELECT R.Netbios_Name0, R.User_Name0, R.Operating_System_Name_and0, R.AD_Site_Name0, IP.IP_Addresses0 From v_R_System R ...
|
-
|
select CS.Name0, NAC.IPAddress0 from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC Join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = NAC.ResourceID Where IPAddress0...
|
-
|
SELECT Case v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 when '1' then 'Other' when '2' then 'Unknown' when '3' then 'Desktop' when '4' then 'Low Profile Desktop' when '5' then 'Pizza...
|
More Posts Next page »
|
|
|