Archive

Archive for the ‘Database’ Category

LANDesk Query Builder

February 17th, 2011 1 comment

LDMSQB is a small utility (written in AutoitScript) that takes a text file of either computer/machine or user/logon names and creates a LANDesk query.

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

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.

How did I get all of these duplicates?

September 16th, 2010 No comments

How did I get all these duplicates? How did I get all these duplicates? How did I get all these duplicates?

Categories: Database, Inventory Tags:

Debug failing scan inserts

September 16th, 2010 No comments

How to figure out why a scan isn’t inserting

Categories: Database, Deep Dives, Inventory Tags:

Reveal script in security threats

September 14th, 2010 No comments

How to analyze or modify the script content in a published security threat

Categories: Database, Endpoint Security Tags:

I Lost My Database Login!

September 14th, 2010 No comments

How to recover your database login information

Categories: Database, Deep Dives Tags:

External Unmodeled Data

September 14th, 2010 No comments

The available options for integration of foreign data

Categories: Database, Deep Dives Tags:

Extend the schema

September 14th, 2010 No comments

How to extend the schema. Or blow your foot off. You decide.

Categories: Database, Deep Dives Tags: