|
Browse by Tags
All Tags » SQL ( 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 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)
|
-
|
I was troubling shooting a WSUS issue and I need to connect to the db to edit some settings. This turns out to be harder than you think when you using Windows Internal db. So how do you connect to the db? Well this post will answer that for you. http...
|
-
|
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...
|
-
|
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 ...
|
-
|
Now that I have your attention, every SMS / ConfigMgr administrator needs to know SQL in order to support SMS/ ConfigMgr. There are no “Ifs” “ands” or “buts” about it, without SQL, ConfigMgr / SMS could not run. You could not write reports or use SSRS...
|
-
|
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 »
|
|
|