Re: software report showing software in add remove programs on all ser

If you clone this report:

"Computers with specific software registered in Add Remove Programs"

There are two prompts, remove the prompt for Software Title.

revise the SQL

From:
Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0,
sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System sys
JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 = @displayname and fcm.CollectionID=@CollID

To:
Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0,
sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System sys
JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID=@CollID

ST

"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:002FA637-955F-42D5-946C-2D5806F02B5B@xxxxxxxxxxxxxxxx
Hi,

I need to get a report which shows all the software installed on all our
servers.

I have tried to clone the "software registered in add remove programs on a
specific computer" and change the sql statement so that i can get this
information for a collection. When i run the clone report i get a http 500
internal server error yet the generic report on a single computer works
fine.

Has someone done this before sucessfully? The sql statement i am using is
below and i was not too sure what i was suppose to do with the sql
prompts. i
have configured the prompt as Name CollectionName with Prompt text
collection
ID and checked "allow an empty Value" and "provide a SQL statement" Prompt
SQL statement=select v_Collection Name
FROM v_Collection

SQL Statement:

Select Sys.Netbios_Name0, coll.Name, prog.DisplayName0, prog.Publisher0,
prog.Version0
From V_R_System Sys
Join v_FullCollectionMembership ship ON ship.ResourceID=Sys.ResourceID
Join v_Collection coll on ship.CollectionID=coll.CollectionID
Join V_GS_ADD_REMOVE_PROGRAMS prog on prog.ResourceID=Sys.ResourceID
WHERE coll.Name = @CollectionName

any help would be appreciated

Regards

Raj



.

Relevant Pages

  • Re: Reporting dates from 2 tables
    ... and from table2 as a prompt for the end ... in SQL? ... I don't know if I should be in the query ... design or the report design. ...
    (microsoft.public.access.gettingstarted)
  • Re: WhereCondition
    ... prompt for the os value. ... computerMake from computer where os like @os ... I have a report that returns ... > appear in an SQL statement: ...
    (microsoft.public.access.reports)
  • Re: Hardware report all machines
    ... > information for all computers in a specific domain", change the Report SQL ... > Then you have to change the Report Prompt. ... > Physical memory, IP Address, CPU Manufacturer, Computer Model, CPU Name, ...
    (microsoft.public.sms.inventory)
  • Re: Dynamic query problem
    ... Imagine you want to desing a query. ... to see the SQL. ... comment out the report and comment in the msgbox. ... I'll assume outcome 1 - no prompt so is ok ...
    (microsoft.public.access.queries)
  • Problem creating a report that prompts for Collection...
    ... I have several sample SMS 2003 SP2 reports that I can get to work if I ... make it prompt me for the Collection ID the report fails with the ... An error occurred when the report was run. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sms.admin)