Sherry, you are a dream ! This is exactly what I need and even more, thank you so much.
From: Sherry Kissinger Sent: Tuesday, April 7, 2015 3:31 PM To: [email protected] Subject: Re: [mssms] Custom report One possibility. Note that, at least in my world, being a laptop doesn't necessarily mean you don't happen to have a Server OS installed on it anyway--so those are two separate things to me. User can be ambigious as well. I went with "last activity" from the client health summary--but what means last activity date can mean different things to different people, too. ;with islaptop as (select case when se.ChassisTypes0 in ('8','9','10','11','12','14','18''21') then 1 else 0 end as islaptop, se.resourceid from v_GS_SYSTEM_ENCLOSURE se ) select sys.Netbios_Name0, sys.User_Name0 [User According to Heartbeat] ,consoleuser.SystemConsoleUser0 [User according to Console Usage] , islaptop.islaptop ,case when sys.Operating_System_Name_and0 like '%server%' then 'Server' when sys.Operating_system_Name_and0 like '%workstation%' then 'Workstation' else sys.Operating_System_Name_and0 end as 'server or workstation' ,cs.LastActiveTime from v_r_system sys left join islaptop on islaptop.resourceid=sys.resourceid left join v_GS_SYSTEM_CONSOLE_USER consoleuser on consoleuser.ResourceID=sys.ResourceID left join v_CH_ClientSummary CS on cs.resourceid=sys.resourceid On Tuesday, April 7, 2015 6:49 AM, Radu Bogdan <[email protected]> wrote: Hello, Does any one know how to create a custom report with the following columns: Computer name, Type ( servers, desktops or laptops ), User name, Last activity date. Thank you. Regards.
