|
|
Browse by Tags
All Tags » System Center » SQL (RSS)
Showing page 1 of 22 (214 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,
...
-
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', ...
-
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 ...
-
SELECT SYS.Netbios_Name0, SF.FileName, SF.FileSize/1024/1024 AS 'Size, KB', SF.FilePath FROM dbo.v_GS_SoftwareFile AS SF INNER JOIN dbo.v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID where (SF.FileName LIKE '%.pdf' AND SF.FilePath LIKE ...
1 ...
|
|
|