|
|
Browse by Tags
All Tags » Code » System Center (RSS)
Showing page 1 of 23 (222 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
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'
-
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', ...
-
I have had few conservation with MS about the AI catalog recently about, What I’m using it for, why is it important, how the catalog is update and when, etc…
Here is what you need to know. MS requires 4 different site to upload an application before it will be categories It takes 30 days for MS for categories an application It ...
1 ...
|
|
|