Remote Control config questions

In addition to the @rrossi suggestion you can take a look at this post:

This is what we suggest to customers when they want to restrict the access to the Targets information. You can also create a report to list all Targets whose access is granted to a specific User group using this SQL:

SELECT DISTINCT A.HWKEY ,A.COMPUTERNAME ,B.IP_ADDRESSES ,B.LOGGED_USER ,A.MANUFACTURER ,A.MODEL ,A.SERIAL_NO ,B.LAST_UPDATE FROM ASSET.ASSET A LEFT OUTER JOIN COMMON.LIVEPOINTS B ON A.HWKEY = B.HWKEY LEFT OUTER JOIN COMMON.GROUPASSETMEMBER G ON A.HWKEY = G.HWKEY WHERE G.GAKEY IN (SELECT GAKEY FROM COMMON.GROUPASSET WHERE G.GAKEY IN ( SELECT DISTINCT A.GAKEY FROM ASSET.PERMISSIONS AS A INNER JOIN ( SELECT GROUPKEY FROM TRCDB.ASSET.USER_GROUP WHERE NAME IN ( 'User group 1' ) ) AS B ON A.GroupKEY = B.GROUPKEY )) ORDER BY A.HWKEY

Replace '‘User group 1’ with the name of your group. You can also add multiple group names separated with ‘,’.

You can follow the same instructions in the post above to set the report as home page to a specific User group and hide the ‘All Targets’ page to non-admin users.

1 Like