Adminsitration Report - for Categories, Subcategories and items
Hi,
There doesn't seem to be a lot of pre-built reports for the lookups used in SDP. I am after a report that details the Categories, Subcategories and items we have created, this is not to be linked with any requests or technicians as we are doing some housekeeping on the lookups and trying to see if we have inadvertently created some duplicate items in different Categories or Subcategories.
I cannot find any information on the table used within SDP so am having difficulty in writing any SQL statement for it.
any ideas on both?
There doesn't seem to be a lot of pre-built reports for the lookups used in SDP. I am after a report that details the Categories, Subcategories and items we have created, this is not to be linked with any requests or technicians as we are doing some housekeeping on the lookups and trying to see if we have inadvertently created some duplicate items in different Categories or Subcategories.
I cannot find any information on the table used within SDP so am having difficulty in writing any SQL statement for it.
any ideas on both?