International About LANDesk| Partners| Contact Us
Up to Discussions in Reporting

This Question is Answered

3 Replies Last post: Apr 17, 2008 11:45 AM by tsmith  
Click to view tsmith's profile Apprentice
tsmith
61 posts since
Dec 14, 2007

Apr 16, 2008 12:15 PM

How do I...query for missing software?

I've been assigned the task of finding out if it is possible to generate a report of specific software missing from any of our machines. ( One machine managed to remove its anti-virus software, and we'd like to check the remaining 250 or so machines. )

 

I've tried playing with the qualifier, but LD seems bent on doing things the way IT wants to do things, and not the way that I want to.

 

Is it possible to run a report on machines withOUT the antivirus SW installed? If so, how?

 

Thanks in advance,

 

Tom

Tags: report, reports, software, sw
Click to view Wintermute's profile Specialist
Wintermute
51 posts since
Dec 18, 2007
1. Apr 16, 2008 2:16 PM in response to: tsmith
Re: How do I...query for missing software?

 

The trouble you're going to find is that LD records information about machines as a per-machine record of what's there - not what is NOT there. (Imagine that potential list!)

 

 

However, if you're specifically looking for antivirus on machines, there are a couple of ways to go about this. In LDMS 8.8, the Inventory scanner tracks the existence of most AV software on the client machines under Security - Antivirus - Antivirus, there is a value called 'Agent Running' and one called 'Auto Protect'. Those values are 'True/False' and 'On/Off' - so that should handily give you what you need.

 

 

If you are not using LDMS 8.8, there is a section of inventory under O/S - Drivers and Services - Services, that should report the existence of AV services (McAfee, Symantec, and LDMS should all show here) and if they are started or stopped. It's a good bet that machines that don't have an AV service listed here aren't running it.

 

 

Click to view ahe's profile Expert
ahe
213 posts since
Dec 21, 2007
2. Apr 17, 2008 7:12 AM in response to: tsmith
Re: How do I...query for missing software?

 

Hello Tom,

 

 

create a query to check the existence of a specific exe file of your virus scanner. I do this for our McAfee:

 

 

"Computer"."Software"."Package"."Filename" Not Like "mcshield.exe"

 

 

The query shows you all computer without this mcshield.exe file.

 

 

 

 

Regards

Axel

 

 

 

 

 

 

(I want to embed a picture, but everytime I try it, my browser crashed...)

 

 

 

 

 

 

Click to view tsmith's profile Apprentice
tsmith
61 posts since
Dec 14, 2007
3. Apr 17, 2008 11:45 AM in response to: ahe
Re: How do I...query for missing software?

Thank you both. I figured it our while I was looking into Wintermute's reply.

 

My first attempt was to look for an absence of the software product name, but couldn't figure out how to get the "Not Exists" into the query. I know, I know, it's right there in that upper middle pane...but I guess I was just trying too hard, and it wasn't registering. So I played with it some more, and got what I need.

 

I now have:

 

"Computer"."Software"."Application Suites"."Application Suite"."Name" Not Exists

AND "Computer"."Software"."Application Suites"."Application Suite"."Name" Not Exists

AND "Computer"."Last Startup Time" Exists

 

And I have what I want. The first two lines check for "Symantec AntiVirus" or "Symantec AntiVirus Client". We have two different versions and one version has the word client in it and the other does not.

 

thanks again,

 

Tom

More Like This

  • Retrieving data ...
LANDesk Community powered by Jive Software's Clearspace ®                                                                        Subscribe| Legal Notices| Investor Relations| Privacy Policy © 2007 LANDesk Software