Service Desk Express – Record Count by Ticket Type

August 14, 2009

If you’re an administrator of BMC Service Desk Express 9.x , you might find these SQL Statements helpful for retrieving the following SDE ticket types.

–INCIDENT Type

SELECT COUNT(*) FROM _SMDBA_._TELMASTE_

–PROBLEM Type

SELECT COUNT(*) FROM _SMDBA_._PROBMGMT_

–CHANGE Type

SELECT COUNT(*) FROM _SMDBA_._CHANGE_

–WORK ORDER Type

SELECT COUNT(*) FROM _SMDBA_._WORKORD_

Expand upon the statements as you need to introduce JOIN or WHERE Clauses. . . The above will get you started anyway. If you need help – just ask.

Thanx – J

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: