tyanni wrote:
I hadn't thought of using the profiler - great suggestion. I'll also take a look at the tool you linked to. Anyone have some queries they'd like to post/send me?
Thanks!
Tim
Tim,
Most advanced use of LANDesk tends to involve some DB-querying at some point, as some reports (for instance) may require such disparate data that we've not provided a report for it, or is impossible to do as a report otherwise through the UI.
The question really is mainly what you're after here - as there's no "top 10 useful queries" (at least not that I know of), as what you're after is a highly individual task. Certainly it'd be a good idea to use Profiler and/or look at the database.
I would STRONGLY recommend using a test core server (with a clean DB) with 1-2 clients to get to grips with the basics, as you will stand much more of a chance to come to terms with things when you've got a small set of data to look at, than having a live production DB with 1000's of clients (potentially) and whatever junk they've collected to deal with.
One thing that I can give you, is a piece of SQL function that will search the entire database for a string. That is documented here:
- http://community.landesk.com/support/docs/DOC-2901
We can try to give a few pointers for places to look at, depending on what data in particular you're keen on.
- Paul Hoffmann
LANDesk EMEA Technical Lead