navigation bar left navigation bar right

Secunia CSI7
navigation left tab Advisories navigation right tab
navigation left tab Research navigation right tab
navigation left tab Forums navigation right tab
navigation left tab Create Profile navigation right tab
navigation left tab Our Commitment navigation right tab
PSI
PSI API
CSI
OSI
xSI
Vulnerabilities
Programs
Open Discussions
My Threads
Create Thread
Statistics
About

Forum Thread: Report on systems not reporting in?

You are currently viewing a forum thread in the Secunia Community Forum. Please note that opinions expressed here are not of Secunia but solely reflect those of the user who wrote it.

This thread was submitted in the following forum:
CSI

This thread has been marked as locked.
jtennys Report on systems not reporting in?
Member 4th Feb, 2012 19:32
Ranking: 0
Posts: 1
User Since: 1st Jan, 1970
System Score: N/A
Location: US
Is there a way to create a report that reports on systems that haven\'t reported in > n days?

I had a bunch of systems that hadn\'t scanned in over 30 days because the IPs changed on csi5.secunia.com (my firewally you have to put in IPs) and I had no idea until I went in and checked on something else.

jlbalvanz RE: Report on systems not reporting in?
Member 6th Feb, 2012 23:56
Score: 3
Posts: 16
User Since: 19th May 2011
System Score: N/A
Location: US
I have a PowerShell script that does this, but it boils down to opening the local Secunia database in SQLite3 ("sqlite3 databasefilename") and executing this SQL:


select nsi_devices.host, nsi_devices.langroup, nsi_devices.updated from
nsi_devices inner join (select host, langroup, updated from nsi_devices where
updated < '2012-01-07') old_machines on nsi_devices.host=old_machines.host EXCEPT
select nsi_devices.host, nsi_devices.langroup, nsi_devices.updated from nsi_devices
inner join (select host, langroup, updated from nsi_devices where
updated >= '2012-01-07') new_machines on nsi_devices.host=new_machines.host
order by nsi_devices.updated;

Put whatever date is appropriate in the correct locations. This will give you a list of machines that haven't checked in since the date listed in columns separated by vertical bars; you can import that into Excel or LibreOffice Calc and make it prettier if you need to. See the CSI documentation for the location of the database.

--
Jeff Balvanz -- Iowa State University Information Technology Services
Ames, IA, USA
Was this reply relevant?
+0
-0

This thread has been marked as locked.


 Products Solutions Customers Partner Resources Company
 
 Corporate
Vulnerability Intelligence Manager (VIM)
Corporate Software Inspector (CSI)
Consumer
Personal Software Inspector (PSI)
Online Software Inspector (OSI)
 Industry
Compliance
Technology
Integration
 Customers
Testimonials
 MSSP
Technology Partners
References
 Reports
Webinars
Events
 About us
Careers
Memberships
Newsroom


Secunia is a member of FIRST Secunia is a member of EDUcause Secunia is a member of The Open Group Secunia is a member of FS-ISAC
 
Secunia © 2002-2014 Secunia ApS - Rued Langgaards Vej 8, 4th floor, DK-2300 Copenhagen, Denmark - +45 7020 5144
Terms & Conditions and Copyright - Privacy - Report Vulnerability - Disclaimer
follow Secunia on Facebook follow Secunia on Twitter follow Secunia on LinkedIn follow Secunia on YouTube follow Secunia Xing follow Secunias RSS feed follow Secunia on Google+