PENDING help to correct please , i am unable to run

[Anil Bhatt]

SELECT distinct

v_R_System.Netbios_Name0 AS "Computer Name",
v_GS_SYSTEM_CONSOLE_USER.SystemConsoleUser0 AS "Console User",
v_GS_SYSTEM_CONSOLE_USER.NumberOfConsoleLogons0 AS "Console Logons",
v_GS_SYSTEM_CONSOLE_USER.TotalUserConsoleMinutes0 AS "Total Minutes on Console",
v_GS_SYSTEM_CONSOLE_USER.LastConsoleUse0 AS "Last Console Use"
from v_R_System INNER JOIN
(SELECT
ResourceID,
SystemConsoleUser0,
NumberOfConsoleLogons0,
TotalUserConsoleMinutes0,
LastConsoleUse0,
ROW_NUMBER() OVER(PARTITION BY ResourceID ORDER BY LastConsoleUse0 DESC) AS Point
FROM
v_GS_SYSTEM_CONSOLE_USER) v_GS_SYSTEM_CONSOLE_USER
ON v_GS_SYSTEM_CONSOLE_USER.ResourceID = v_R_System.ResourceID
AND v_GS_SYSTEM_CONSOLE_USER.Point = 1
Order by v_R_System.Netbios_Name0

CS.name0 as 'Computer Name',

CS.domain0 as 'Domain',

CS.UserName0 as 'User',

BIOS.SerialNumber0 as 'Bios serial',

SE.SerialNumber0 as 'System Enclosure serial',

CS.Manufacturer0 as 'Manufacturer',

CS.Model0 as 'model',

OS.Caption0 as 'OS',

RAA.SMS_Assigned_Sites0 as 'Site',

RAM.TotalPhysicalMemory0 as 'Total Memory',

sum(isnull(LDisk.Size0,'0')) as 'Hardrive Size',

sum(isnull(LDisk.FreeSpace0,'0')) AS 'Free Space',

CPU.Name0 AS 'CPU Name'

from

v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID

right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID

right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID

right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID

right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID

right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID

right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID

right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID

where

LDisk.DriveType0 =3

group by

CS.Name0,

CS.domain0,

CS.Username0,

BIOS.SerialNumber0,

SE.SerialNumber0,

CS.Manufacturer0,

CS.Model0,

OS.Caption0,

RAA.SMS_Assigned_Sites0,

RAM.TotalPhysicalMemory0,

CPU.Name0

 

[Prajwal Desai]

Can you brief us on what are you trying to achieve with this query?

 

[Garth]

Are you running this query within the CM console or SSMS? This query is a SQL query and NOT a CM collection query.