|
|
Browse by Tags
All Tags » System Center » ConfigMGr (RSS)
Showing page 1 of 18 (172 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 ...
-
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 = ...
-
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 ...
-
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 R .Name0 From dbo .v_R_System R join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID = CS.ResourceID join dbo.v_RA_System_SystemOUName OU on R.ResourceID = OU.ResourceID Where CS .Model0 = 'Virtual Machine' Group by R .Name0, CS .Model0 Having ...
-
select Name, Value, Masked from MEP_MachineVariables where MachineID = 63
-
SELECT Distinct SYS.Netbios_Name0 , SYS.Operating_System_Name_and0 , MEM .TotalPhysicalMemory0/1024 As C083 FROM v_R_System SYS JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID WHERE User_Name0 = 'Garth'
-
Select D istinct R.Netbios_Name0 AS 'Computer Name',
SCU.SystemConsoleUser0 as 'User', S.SiteName as 'SMS Site Name',
SEU.SerialNumber0 AS 'Serial Number',
SEU.SMBIOSAssetTag0 AS 'Asset Tag',
CS.Manufacturer0 AS 'Manufacturer',
CS.Model0 AS 'Model', ...
-
select Distinct CS .Name0, CS .Domain0, OS .Caption0 From dbo .v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where ...
1 ...
|
|
|