How to avoid a technician with the “EnableCMDB” role to see CMDB items of all accounts instead of associated accounts.
Default Role “EnableCMDB” the technician can see all the CMDB items of all accounts. Along with the EnableCMDB role, you add a custom role with the Technician Allowed to View set as All in associated Accounts
New to ADSelfService Plus?
Related Articles
Query to show technicians associated accounts, sites and Support groups - (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 1.Technicians and associated Accounts/Sites: select aau.User_id, aau.first_name "First Name", sdu.lastname "Last Name", aal.name "Login Name", AaaContactInfo.EMAILID "Email Address",sdu.jobtitle "Job ...Unassociated Account/sites are visible for technicians
Issue: -> When trying to associate only one account or site for a technician there is an issue where other account and sites are automatically associated -> Even though the technician is given the role "SDAccount Admin" they automatically get access ...Query to find technicians with login enabled along with sites and account associated (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Please go to Reports-New Query reports and execute this query. select aau.User_id,aau.first_name "Technician Name", aal.name "Login Name", aal.Domainname "Domain",sdo.name "Associated ...Query to get technician details(domain, associated account, email) from builds (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) SELECT aau.first_name "First Name", sdu.lastname "Last Name", AaaContactInfo.EMAILID "Email Address", sdo.name "Associated Sites", adef.org_name "Associated Accounts", df.domainname "Domain Name" ...Query to show time elapsed in a ticket with SLA associated (PGSQL)
Tested in PGSQL build (14300) PGSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", ti.FIRST_NAME AS "Technician", cd.CATEGORYNAME AS "Category", std.STATUSNAME AS "Request Status", LONGTODATE(wo.CREATEDTIME) "Created Time", ...