SMS Reporting question
- From: UnderCoverGuy <UnderCoverGuy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 03:00:01 -0800
Good morning. I have a question that I can't find the answer to. Is it
possible to tally columns based on a column value? In other words, in the
following report, I would like to display a total count at the end of the
report. Something like...
Virtual Systems - Quantity x
1GB PC2700 - Quantity x
Unknown - Quantity x
etc...
Thanks in advance,
UCG
------------------------------------------------------------------------------------
select distinct
v_GS_Computer_system.Name0 AS "PC Name"
, v_GS_Computer_system.UserName0 AS "User last logged on"
, v_GS_Operating_System.caption0 AS "OS"
, v_gs_Operating_system.csdversion0 AS "SP Level"
, v_GS_Computer_system.manufacturer0 AS "Make"
, v_GS_Computer_system.model0 AS "Model"
, v_GS_x86_PC_memory.totalphysicalmemory0 AS "RAM Installed"
, case v_GS_Computer_system.model0
when 'Virtual Machine' then 'Virtual'
when 'VMware Virtual Platform' then 'Virtual'
when 'Evo D310v' then '1'
when 'Evo D500 USDT' then 'Unknown'
when 'Evo D510 CMT' then '1'
when 'Evo D510 SFF' then '1'
else 'Unknown'
end as 'RAM Quantity'
, case v_GS_Computer_system.model0
when 'Virtual Machine' then 'Virtual'
when 'VMware Virtual Platform' then 'Virtual'
when 'Evo D310v' then '1GB PC2700'
when 'Evo D500 USDT' then 'Need to examine system'
when 'Evo D510 CMT' then '1GB PC2700'
when 'Evo D510 SFF' then '1GB PC2700'
else 'Unknown'
end as 'Ram Type'
, v_gs_processor.maxclockspeed0 AS "CPU Speed"
, cast(v_gs_video_controller.CurrentHorizontalResolution0 as Varchar) + ' x
' + cast(v_gs_video_controller.CurrentVerticalResolution0 as varchar) AS
"Video Resolution"
from
v_gs_computer_system,
v_GS_x86_PC_memory,
v_GS_processor,
v_gs_video_controller,
v_GS_Operating_system
WHERE
v_gs_operating_system.resourceid = v_gs_computer_system.resourceid
and v_gs_computer_system.resourceid = v_gs_computer_system.resourceid
and v_GS_x86_PC_memory.resourceid = v_gs_computer_system.resourceid
and v_GS_processor.resourceid = v_gs_computer_system.resourceid
and v_GS_video_controller.resourceid = v_gs_computer_system.resourceid
and v_GS_Operating_system.caption0 NOT like '%2000 Server%'
and v_GS_Operating_system.caption0 NOT like '%Server 2003%'
and v_GS_video_controller.CurrentHorizontalResolution0 <> ""
and v_GS_x86_PC_memory.totalphysicalmemory0 < '1024768'
Order by
v_gs_computer_system.name0
----------------------------------------------------------------------------------
Thanks again,
UCG
.
- Follow-Ups:
- Re: SMS Reporting question
- From: Garth
- Re: SMS Reporting question
- Prev by Date: Re: Max. number of clients connection at one time
- Next by Date: Re: Lookup value in row and column based on cell criteria
- Previous by thread: Lookup value in row and column based on cell criteria
- Next by thread: Re: SMS Reporting question
- Index(es):
Relevant Pages
|
