Posts Tagged ‘Queries’

How to find machines not in a static group

September 16th, 2010 No comments

How to find machines that are in all devices, but not in a static group. Leverages Corrie’s “Automatically Update Device Groups” on this site, but is used to get machines that aren’t able to be grouped together via a query grouped.

How to make device groups update automatically

September 16th, 2010 2 comments

The device groups that can be created in LANDesk can only be updated manually. This is a workaround to update those groups automatically using SQL.

Use regular expressions in queries

September 16th, 2010 No comments

Power query building

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

Not using the Domain?

September 15th, 2010 No comments

Locate machines that aren’t using domain accounts most of the time

Categories: Deep Dives, Inventory Tags: ,