RE: Hardware report with Prompt

This report requires a prompts.

Report Name: Computers by a specific Model

Select SYS.Netbios_Name0 as 'Machine Name',
PCB.SerialNumber0 as 'Serial No',
SYS.User_Name0 As 'User',
SYS.AD_Site_Name0 AS Site,
OPSYS.Caption0 AS 'Operating System',
OPSYS.CSDVersion0 AS 'Serv Pack',
SYST.Model0 as Model,
'Chassis Type' =
Case
SYSE.ChassisTypes0
when '1' then 'Other'
when '2' then 'Unknown'
when '3' then 'Desktop'
when '4' then 'Low Profile Desktop'
when '5' then 'Pizza Box'
when '6' then 'Mini Tower'
when '7' then 'Tower'
when '8' then 'Portable'
when '9' then 'Docking Station'
when '10' then 'Notebook'
when '11' then 'Hand Held'
when '12' then 'Laptop'
when '13' then 'All in One'
when '14' then 'Sub Notebook'
when '15' then 'Space-Saving'
when '16' then 'Lunch Box'
when '17' then 'Main System Chassis'
when '18' then 'Expansion Chassis'
when '19' then 'SubChassis'
when '20' then 'Bus Expansion Chassis'
when '21' then 'Peripheral Chassis'
when '22' then 'Storage Chassis'
when '23' then 'Rack Mount Chassis'
when '24' then 'Sealed-Case PC'
else 'Undefinded'
end
from v_R_System SYS
Left JOIN v_GS_SYSTEM_ENCLOSURE SYSE ON SYS.ResourceID = SYSE.ResourceID
Left Join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID = OPSYS.ResourceID
left join v_GS_COMPUTER_SYSTEM SYST ON SYS.ResourceID=SYST.ResourceID
left join v_GS_PC_BIOS PCB on SYS.ResourceID=PCB.ResourceID
where
(SYST.Model0 like @mt And @mt<> '') Or
(SYST.Model0 Is NULL and (@mt Is NULL or Upper(@mt) like '' Or Upper(@mt)
like 'NULL'))
order by SYS.Netbios_Name0
---------------
Prompt

Name: mt
Prompt text: Model Type

Sql statment for prompt:

begin
if (@__filterwildcard = '')
select distinct Model0 as Model from v_GS_COMPUTER_SYSTEM order by Model0
else
select distinct Model0 as Model from v_GS_COMPUTER_SYSTEM
WHERE Model0 like @__filterwildcard
order by Model0
end
---------------------------

Dale
--
(if you like the post please rate it)


"Danny M" wrote:

> Don't worry about this...I've come up with another way around this through
> the queries.. I made a query and got the details I wanted...I'll now just
> copy that across to the reporting section...I'll just follow this procedure
> until I become acustomed to the language (that's right, I'm new to SQL
> querying language).
>
> cheers
> --
> D
>
>
> "Danny M" wrote:
>
> > I'm trying to generate a report that will list the all the computers of a
> > particular model I'm after from the databases. I've referenced a couple of
> > the queries other people have posted which has been a great help, but any
> > more help would be much appreciated...
> > --
> > D
.

Relevant Pages

  • RE: Hardware report with Prompt
    ... Nice report, I'm going to use this one! ... Computers by a specific Model ... > when '17' then 'Main System Chassis' ... > Prompt text: Model Type ...
    (microsoft.public.sms.inventory)
  • RE: Report Parameters
    ... If there are multiple subreports that need the dates, ... If only one subreport needs dates, then you can cause it to prompt for the ... Dave Hargis, Microsoft Access MVP ... particular sub report that need start and end dates specific to the pts. ...
    (microsoft.public.access.reports)
  • RE: Report Parameters
    ... Dave Hargis, Microsoft Access MVP ... it actually runs the report again which causes the ... report prompt for each pt. ...
    (microsoft.public.access.reports)
  • RE: Report Parameters
    ... it runs the report which causes the prompt. ... Dave Hargis, Microsoft Access MVP ... another for EndDate, but since each subreport has it's own query, each query ...
    (microsoft.public.access.reports)
  • RE: Report Parameters
    ... I have no choice but to use text boxes. ... it actually runs the report again which causes the ... Dave Hargis, Microsoft Access MVP ... report prompt for each pt. ...
    (microsoft.public.access.reports)
Quantcast