Re: Software Reporting

You will find lots of SQL and WQL queries on http://myitforum.com/, I think
that steve has a blog there as well. Also look for and MVP & User group web
sites as many of them have blog and forum that you can get more help.


"FlaglerCollege" <FlaglerCollege@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98D9D914-DB6D-4BD8-B0F7-8B0A562090B0@xxxxxxxxxxxxxxxx
Steve, this information was so helpful! Thank you!! Since I am not the
best
at SQL query,
may I ask where you got this or did you make this yourself? I was just
wondering as I would
love to find a place online that has additional custom report/query
samples
as well.

Thank you!

"Steve Thompson" wrote:

"FlaglerCollege" <FlaglerCollege@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:727408E0-7010-44D5-9C65-B81192088365@xxxxxxxxxxxxxxxx
Does anyone have a report that will check all machines that do NOT have
a
particular software package installed? I can find everything about what
is
on
a machine however I would like to see if software is missing off of a
machine
such as Symantec AntiVirus.

Hopefully this helps... it's a collection template query that we created
to
located all devices without a specific file installed. The "magic" is
using
the subselect query, then the "Not In" logic to sift out those devices
that
have it installed.

select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System inner join SMS_G_System_SYSTEM on
SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SYSTEM.ResourceID not in (select distinct
SMS_G_System_SYSTEM.ResourceID from SMS_R_System inner join
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SoftwareFile.FileName = "KAP-02_05-020520.wse")





.

Relevant Pages

  • Re: Group By versus Distinct
    ... And I agree with Steve - prefer GROUP BY ... Dejan Sarka, SQL Server MVP ... > We have our "ten commandments" of query building posted on the wall here ... > What is your real reason for wanting to use the GROUP BY or DISTINCT ...
    (microsoft.public.sqlserver.server)
  • Re: Get back uniqueid?
    ... I added another query to the table, ... Would I not need a stored procedure for a compound SQL stamement? ... Blog: http://cs.rthand.com/blogs/blog_with_righthand/ ... the datatable after calling update, but as it stands I just access the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Filtering records based upon another table
    ... Steve, your help is greatly, greatly appreciated. ... Here is the SQL from the query for the "county" drop down box: ... SELECT [County List].County ... County List Query ...
    (microsoft.public.access.macros)
  • Re: Null Expression
    ... Steve wrote: ... I don't understand why you posted a different query. ... SQL View, via the View menu, or the toolbar button, or the ... I think you should post a few rows of sample data from each table (just the ...
    (microsoft.public.access.queries)
  • Re: Group By and Having
    ... Here's what's happening when I use your query: (PBR is the real name of the ... Here's the SQL of the query I used: ... > Steve Schapel, Microsoft Access MVP ... Carol. ...
    (microsoft.public.access.queries)
Quantcast