Custom Queries: Table Names?
I'm using ServiceDesk version 5.5.0 We have contracts in our database by server name. I need to create a report that pulls the contracts by status (expired, will expire in 30 days, etc) and also includes the service tag for the server name (which is also the contract name).
I tried to do this, but couldn't because I did not know the name of the table that contains Contract or Workstation information.
Could someone give me the appropriate table names for the report I need to create?
I tried to do this, but couldn't because I did not know the name of the table that contains Contract or Workstation information.
Could someone give me the appropriate table names for the report I need to create?