Kaseya – Querying and Reporting

I notice a few people are finding this blog as a result of searching for ways to report on the Kaseya database.

I did start looking into this a few months ago, but have moved on. I hereby make a gift to you of my entire collection of notes on the subject:

  • Tables named “auditRslt*” are useful
  • Need to link on “agentguid” fields, which could be a pain
  • Views everywhere – and they’re useful.

This has been a public lack-of-service broadcast.  I suspect it is of no use at all.  Enjoy.

(Incidentally, that’s the second time today I’ve written up those notes.  I suspect Kaseya will be reappearing in my near future.  Oh well.)

This entry was posted in SQLServerPedia Syndication, Uncategorized and tagged . Bookmark the permalink.

3 Responses to Kaseya – Querying and Reporting

  1. Kaseya provides lots of database views and web services to easily get at data for reporting purposes. We highly recommend you access data through these views rather than directly accessing the database tables. With each release, Kaseya changes the database schema (sometimes minor but sometimes quite a bit). The views are fully supported and don’t change from release to release. Plus, we documented them. Check out our online documentation at http://help.kaseya.com/WebHelp/EN/VSA/6000000/index.htm?toc.htm?532.htm.

  2. thomasrushton says:

    Hi Mark

    Thanks for that. I’ll make sure it gets to the appropriate people both here & at the previous place.

  3. Pingback: 2010 in review – according to WordPress | The Lone DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.