Posts Tagged ‘sql’

LANDesk 8.8 tables you actually care about

September 23rd, 2010 No comments

Below is the list of tables you’ll want to consider when doing any direct querying of the LANDesk database.  Beneath the table name are the columns you’ll find the most useful data in.  This is not comprehensive, its meant to narrow down your search through the database schema. Know of some key ones we missed? […]

Categories: Database Tags: , ,

Last 24 hours of scheduled tasks

September 16th, 2010 No comments

SQL Query for the details of the most recent tasks

Categories: Reports Tags: , , ,

Scans in this hour and this day

September 16th, 2010 No comments

More SQL-FU in the query builder

Categories: Reports Tags: , , ,

Report machines that aren’t scanning anymore

September 16th, 2010 1 comment

How to make a report that identifies machines which haven’t scanned successfully recently

Categories: Reports Tags: , , , ,