Hi,In order to better manage the ITIL licenses, I need to find those ITIL users who have not performed any activity in the system.Is there an easy way to find this?
Hi,I am relatively new to SNOW. I was trying to connect to SNOW database via ODBC. The idea is to pull data into a local SQL Server database.I was successfully able to create a linked server and connect to the SNOW db. I am also able to query the Inc...
A similar requirement came up recently and I was wondering if anyone has done this integration. I wanted to understand if there are any performance issues when the scan takes place.
To be specific, I would like to understand if an ITIL user has performed any activity (e.g updated the worknotes, resolved any tickets etc) on any tickets. If they have not, then we plan to remove there ITIL role and save on license.
Hi Tony,I created a ACL on column 'element' and I was able to pull data for that column. Will try to create ACLs for other columns as well and see if it works. But not sure why I have to create at column level when I already have one at table level.T...
Hi Tony,I did follow all the steps defined above.Here is the query I am using:select * from OPENQUERY(SERVICENOW,'select [label],element,dependent_value,[hint],language,cast(sequence as int),sys_id,value from sys_choice order by [label] asc')I am get...
