Hi Experts,
Please find the below information and give me your hands on the below queries.
1 Dql query to get the List of ****_webtop Users
Required columns list.
-User name
- Date of last ****_webtop access
- Total numbers of days of ****_webtop access previous 6 months
select user_name,last_login_utc_time as edocs_last_access_date from dm_user where
datediff(day,last_login_utc_time,date(today))>180
Note:From this below query i can get only usernames and last logintime last privious 180 days.but How to get Total numbers of days of ****_webtop access previous 6 months.
suppose xx is the user and he logged in webtop in this month Aug 5,8,21.then i need to get the count is:3.
2.List of users with ****- folder access(example hierarchy-cabinets/aaa-cabinet/bb-folder/****-teamfolder)
list of columns:
- **** File name
- **** File ID
- Users name(s)
Here the conditionis:
All roles defined for **** Team folder have read access, so consolidated users from all roles has to display?
3.List of documents user is working on that are in workflow or quickflow
List of columns to display:
- Document name
- Workflow or quickflow status
- Number of days in workflow or quickflow
- C_File name
- C-File ID
- E-File name
- E-File ID
- E- File Owner name(s)
Here the condition is :Check what documents are currently waiting for team member action
4.List of documents in workflow or quickflow
List of columns to display:
- Document name
- Workflow or quickflow status
- Number of days in workflow or quickflow
- C_File name
- C-File ID
- E-File name
- E-File ID
- E- File Owner name(s)
Here the conditionis:
Keep track of documents in workflow or quickflow;means who is working for what.
file owner needs to see ,team member is working on what?and also team meamber manager and partner is working on what?
Thanks&Regards
Hari
