Posts Tagged ‘8.8’

Jack Coates’ server BKM doc

September 23rd, 2010 1 comment

The man, the myth, the legend gives his thoughts on how to build a LANDesk 8.8 server

Categories: Deep Dives Tags: , , ,

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: , , ,

Use regular expressions in queries

September 16th, 2010 No comments

Power query building

Categories: Reports Tags: , ,

Sample reports

September 16th, 2010 No comments

A collection of customized reports that can be used as examples

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: , , , ,

Get counts of types

September 16th, 2010 No comments

How to get counts instead of listings

Categories: Reports Tags: , , ,

Generic AV out-of-date query

September 16th, 2010 No comments

I’ve heard from the machine within a week, an AV product is installed, but its DAT file publication date is more than a week old

Categories: Technology Tags: , ,

Edit the qualifier in a query

September 16th, 2010 No comments

Need a dynamic qualifier to make reporting more useful in a custom query? This tip will allow you to make SQL commands in the qualifier on any column you specify.

Categories: Reports Tags: , ,