Open-AudIT

What's on your network?
It is currently Mon Apr 23, 2018 1:50 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Fri Mar 09, 2007 7:59 pm 
Offline
Contributor

Joined: Fri Jul 28, 2006 6:30 am
Posts: 157
Location: London
It took me a while to figure this out myself so I thought I'd share.

If you want a list of systems with the install status of a particular OS hotfix, the query below will give it you. Simply change the KB number in the relevant places in the query.

Cheers, Nick.


Code:
SELECT * FROM
(
SELECT system_name, 'Installed'  as kb926666 FROM software, system
WHERE software_name LIKE '%kb926666%' AND software_uuid = system_uuid

UNION

SELECT DISTINCT system_name, 'Not Installed' AS software_name
FROM system WHERE system_name NOT IN
  (SELECT DISTINCT system_name FROM software, system
  WHERE software_name LIKE '%kb926666%' AND software_uuid = system_uuid)
)
AS U
ORDER BY system_name;


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Sat Mar 10, 2007 1:38 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
A nice fix here would be to improve the search box, so we can just paste in the KB number.

_________________
Andrew

OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group