|
|
Browse by Tags
All Tags » Code » SMS (RSS)
Showing page 1 of 31 (306 total posts)
-
For full details see. http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/cf7d80a0-1a7c-430c-b33a-ee47a0efa806
select
CS.Name0,
LCU.date
From
dbo.v_GS_COMPUTER_SYSTEM CS
join ( Select
ResourceID,
max(LastConsoleUse0) as 'date'
from
dbo.v_GS_SYSTEM_CONSOLE_USER ...
-
See Forum post for fill details. select distinct
SMS_R_System.Name,
SMS_R_System.Client,
SMS_R_System.LastLogonUserName,
SMS_R_System.ADSiteName,
SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory,
SMS_G_System_PROCESSOR.NormSpeed
from
SMS_R_System
inner join SMS_G_System_X86_PC_MEMORY on ...
-
SELECT DISTINCT
COMSYS.Manufacturer0,
COMSYS.Model0,
Client.Version0,
Count(*)
FROM
v_GS_COMPUTER_SYSTEM COMSYS
JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID
JOIN v_GS_PROCESSOR PROC1 ON COMSYS.ResourceID = PROC1.ResourceID
JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID
...
-
SELECT DISTINCT
COMSYS.Manufacturer0,
COMSYS.Model0,
Count(*)
FROM
v_GS_COMPUTER_SYSTEM COMSYS
JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID
JOIN v_GS_PROCESSOR PROC1 ON COMSYS.ResourceID = PROC1.ResourceID
JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID
JOIN ...
-
select
NetBiosName as "CAM NetBiosName",
LastPolicyRequest as "CAM LastPolicyRequest",
LastDDR as "CAM LastDDR",
sy.Operating_System_Name_and0 as "Operating System",
sy.Resource_Domain_OR_Workgr0 as "AD Domain",
NAC.IPAddress0
from
v_CH_ClientSummary
inner join v_R_System as ...
-
SELECT
S.Name0 AS [System Name],
OS.Caption0 AS [Operating System],
OS.CSDVersion0 AS [Service Pack],
OS.InstallDate0 AS [Original OS Install Date],
OS.LastBootUpTime0 AS [Last Boot Time],
NAC.IPAddress0 AS [IP Address],
NAC.IPSubnet0 AS [Subnet Mask],
NAC.DefaultIPGateway0 AS [Gateway],
NAC.DNSServerSearchOrder0 AS [DNS ...
-
Select
Name0
From
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID
Where
CS.ResourceId in (select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = 'Windows Server 2003 Service Pack 2')
and CS.ResourceId in (select ARP.ResourceId from ...
-
select
v_R_System.Name0 as 'Computername',
Count(v_StateNames.Statename) as 'Required Updates'
from
v_StateNames,
v_Update_ComplianceStatusAll
Inner Join v_R_System On (v_R_System.ResourceID = v_Update_ComplianceStatusAll.ResourceID)
Inner Join v_UpdateInfo On (v_UpdateInfo.CI_ID = ...
-
http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/c23b6c8f-57a7-4bdf-932e-e28060d4323d
select
CS.Name0,
NAC.IPAddress0
from
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID
Where
NAC.IPAddress0 != ''
Group by
CS.Name0,
...
-
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 ...
1 ...
|
|
|