|
|
Browse by Tags
All Tags » Code (RSS)
Showing page 1 of 29 (282 total posts)
-
select
*
from
SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.Name like "TTDR___AC__W___"
-
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 ResourceID from dbo.v_GS_SoftwareFile where FileName = ...
-
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
SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like ...
-
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 (GHz)',
ROUND (ROUND(CONVERT (FLOAT ...
-
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 new site will come a new look a feel. (wait for it) If you are looking ...
-
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]
,[PresentTime]
...
-
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 = 'Update for Windows Server 2003 (KB923845)'
-
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 is HEX this will give you ~1/16 of all of those ...
1 ...
|
|
|