|
|
Browse by Tags
All Tags » Code » ConfigMGr (RSS)
Showing page 1 of 21 (210 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 ...
-
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,
...
-
I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox!
If you want to download the PPT, you can find it in Enhansoft’s blog ...
-
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 = ...
-
SELECT adv .AdvertisementName, stat .LastStateName, adv .Comment AS C072, pkg .Name AS C062, adv .ProgramName AS C071, adv .SourceSite, adv .AdvertisementID, se .SerialNumber0, cs .UserName0, Stat .LastAcceptanceStatusTime FROM v_Advertisement adv JOIN v_Package pkg ON ...
1 ...
|
|
|