Workspace Audit information collection
The below query could be used to collect the audit information requested by connecting to the Analytics Plus database using local DB import.
select dbobj.displayname AS "View Name", createdusermail.email_id as "Created By", to_timestamp(createdtime/1000) AS "Created On", modusermail.email_id AS "Last Modified By", to_timestamp(lastdesignmodtime/1000) AS "Last Modified Time"
FROM zdbdbobject dbobj left join iamuser createduser on dbobj.owner_zuid=createduser.zuid left join iamuseremail createdusermail on createduser.user_auto_id=createdusermail.user_auto_id left join iamuser moduser on dbobj.designmodby_zuid=moduser.zuid left join iamuseremail modusermail on moduser.user_auto_id=modusermail.user_auto_id where dbobj.dbid=<DBID> and dbobj.type!=8;
Replace the <DBID> with the workspace ID of the respective workspace that you wish to perform audit on.
Workspace ID is the number shown in the URL when you open a workspace or the number shown in the workspace hyper link.
For connecting to the Analytics Plus database, please refer the below connection details.
Hope that helps.
Note: Please reach out to support team to find the PostgreSQL password.
New to ADSelfService Plus?
Related Articles
CAB recommendation table is not updated with recent data - External
Issue: CAB recommendation table in ServiceDesk Plus workspace is not updated with recent data. Note: This KB is applicable for ServiceDesk Plus version from 11128 till the latest version Cause: ServiceDesk Plus has made framework level changes and ...How to pull the attachment information of all the users from Servicedesk plus to Analytics plus ?.
If you are looking to import the information for the attachment of the user module as shown below, Sample imported table in the Analytics plus UI: Then, please follow the below instructions: 1. Login to your Analytics Plus and go-to your ServiceDesk ...Query to Fetch Inactive Columns from a Workspace
Requirement: Customer wanted to determine the number of used or unused columns in a workspace. Solution: To achieve this, we need to connect to the Analytics Plus database by using local database import method (PostgrSQL) and then use the custom ...Upgrade to AnalyticsPlus 5400 Fails for Users with Missing zsoid Values
Issue Upgrading from builds between 5301 and 5360 to build 5400 fails because the zsoid field for some users is null. Error Trace java.sql.SQLException: This column [ZSOID] has some null values, hence it cannot be modified as not-null. Cause The ...Sync issue between SDP MSP and Aplus
Issue: Sync fails between ServiceDesk Plus MSP and AnalyticsPlus, after upgrading the SDP to 14730. Cause: An example of a case mismatch issue is when Analytics Plus seeks column alias names such as BillID, but MSP returns BILLID instead. This is a ...