
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-14-2011 07:13 PM
i'm trying to create a query that shows me all the computers that does not have a software package installed. but i get the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
the query look as followed
the sub query runs fine and gives all the pc's that have the software installed.
i now need a revered list with all the other computers.
the errors message is logical because i get a list. but i'm not sure how to do it else.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
the query look as followed
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer != (Select tblComputers.Computer
From tblComputers Inner Join tblsoftware On tblsoftware.ComputerName =
tblComputers.Computername
Where tblsoftware.softwareName = 'Software package that needs to be checked')
the sub query runs fine and gives all the pc's that have the software installed.
i now need a revered list with all the other computers.
the errors message is logical because i get a list. but i'm not sure how to do it else.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-14-2011 10:58 PM
try this
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select ComputerName
From tblsoftware
Where softwareName = 'Software package that needs to be checked')
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2011 09:12 PM
This code is what i was looking for.
But I wonder if it's possible to have only one report where I could enter the software name as a parameter when I run it. This would avoid making a lot of reports.
Or even better, directly in the software overview, is it possible to view the computers where the software is not installed?
But I wonder if it's possible to have only one report where I could enter the software name as a parameter when I run it. This would avoid making a lot of reports.
Or even better, directly in the software overview, is it possible to view the computers where the software is not installed?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2011 02:50 PM
robintre wrote:
But I wonder if it's possible to have only one report where I could enter the software name as a parameter when I run it. This would avoid making a lot of reports.
This is only possible in the configuration console. You can change the software criteria and instantly rerun the report. You cannot currently do this from the web console.
robintre wrote:
Or even better, directly in the software overview, is it possible to view the computers where the software is not installed?
No, this is not currently possible. Clicking on links in the software overview on the website will only show computers that do have the software installed, not ones that don't.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-15-2011 11:07 AM
thanks that helped alot
this is what i needed:
this is what i needed:
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select tblComputers.Computer
From tblComputers Inner Join tblsoftware On tblsoftware.ComputerName =
tblComputers.Computername
Where tblsoftware.softwareName = 'Software package that needs to be checked')

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-14-2011 10:58 PM
try this
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select ComputerName
From tblsoftware
Where softwareName = 'Software package that needs to be checked')
