|
|
Browse by Tags
All Tags » System Center » SCCM (RSS)
Showing page 1 of 5 (50 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 ...
-
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 ...
-
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 DISTINCT
a.Netbios_Name0 AS 'Computer Name',
CASE WHEN ARP.OMSA IS NULL THEN 'N/A' ELSE ARP.OMSA END AS 'Dell OMSA Version',
CASE WHEN ARP.Equallogic IS NULL THEN 'N/A' ELSE ARP.Equallogic END AS 'Broadcom Version'
FROM
v_R_System_Valid a
INNER JOIN v_GS_COMPUTER_SYSTEM ...
-
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'
1
|
|
|