Products on a specific collection report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I need to know if there is a way that I can edit this query to display
All the products using a collection ID? I'm a newbie SMS guy and I've
been trying to create a query that works for the past couple of hours
and can't seem to get it to work.

I'm using the "Products on a specific computer" query (below) as a
template.


Select DISTINCT
SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName,
SP.ProductName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
Where SYS.Netbios_Name0 Like @variable
ORDER By SP.CompanyName, SP.ProductName, SP.ProductVersion


Any help appreciated.


Thank you!


Chris

.

Relevant Pages

  • Re: DB Result Wizard Error
    ... open the hidden folder /_fpclass/ and edit the ... > For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... > to display the new equipment information. ... > is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • Re: Edit filtered record
    ... But I can not edit ... You mean that the form you open to display the detailed information doesn't ... (Check the code that opens the ... Is the form based on a query that is not updatable? ...
    (microsoft.public.access.forms)
  • Re: Despite Data Entry = False the edit box appears for the list & fields overflow
    ... Use the MsoBoundSpan element to display the data, ... "Karen Middleton" wrote in message ... > query and I have published a data Access page against the Access ... > access page shows all the cells data in a Edit box even though I ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Despite Data Entry = False the edit box appears for the list & fields overflow
    ... DataEntry set to False does not prevent data entry. ... > query and I have published a data Access page against the Access ... > access page shows all the cells data in a Edit box even though I ... > table to display the data. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)