|
|
Browse by Tags
All Tags » ConfigMGr (RSS)
Showing page 1 of 33 (321 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 distinct
SMS_R_System.Name,
SMS_R_System.ResourceId
from
SMS_R_System
where
SMS_R_System.ResourceId in ( select
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = ...
-
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 ...
-
With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/ MIF is truly a community that helps each other both professionally and personally. But it cost thousands ...
-
Select distinct
ou.system_ou_name0,
sys.Netbios_Name0,
fcm.SiteCode,sys.User_Domain0,
sys.User_Name0,
-- DATEADD(mi,(usr.lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)],
usr.company0,
sys.Operating_System_Name_and0,
Displayname0,
Version0,
InstallDate0
FROM
dbo.v_R_System sys
JOIN ...
-
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,
...
1 ...
|
|
|