Reports

I know you know that I know that you know this thing that he knows

Adding the Date To Your Reports — by WhiteSS — last modified 2008-01-18 11:33

An easy solution to a problem that took me an hour to figure out.

Adding total to reports — by jmounivong — last modified 2007-01-24 07:13

Put totals into your custom reports

Collapsing Data in Reports — by jmounivong — last modified 2008-03-22 11:00

List one device name for multiple rows of data

Edit the Qualifier in a Query — by Denny Cannon — last modified 2007-11-08 13:26

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.

Generic AV Out-of-Date Query — by jack — last modified 2009-04-01 15:56

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

Get Counts of Types — by jack — last modified 2008-09-18 17:00

Report the number of things rather than a list of things

Last 24 hours of scheduled tasks — by jack — last modified 2009-03-30 08:19

SQL Query for the details of the most recent tasks.

Recent Software Installations — by DaveE — last modified 2008-11-13 08:43

If Add/Remove Programs has Installed Date filled in, this will work; in other words, expect partial success.

Report Center for LANDesk — by adampound — last modified 2008-03-24 12:47

html front end

Report machines that aren't scanning any more — by jack — last modified 2007-06-14 09:03

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

out of date query.png — by jack — last modified 2007-06-14 09:03

 

Sample Reports — by egarlepp — last modified 2008-09-27 08:54

A collection of customized reports that can be used as examples

Scans in this hour and this day — by jack — last modified 2008-10-09 16:08

More SQL-FU in the query builder

SQL Training Course — by Denny Cannon — last modified 2007-04-27 14:23

If you have to go directly to the database

SQL Training Course Part Two — by Denny Cannon — last modified 2007-04-27 14:25

For the really deep dive

Use Regular Expressions in Queries — by jack — last modified 2009-02-24 16:52

Power query building

Power Report — by jack — last modified 2009-04-02 16:27

Show what LANDesk inventory has gathered or done