Database view using sysevent table

dickhirsch · ‎03-09-2015

I'm trying to combine the sysevent and sys_user tables in a database view to capture login-related events.

I've been struggling to get it working.

Every time, I want to test it - it crashes. I have no idea why.

Thanks,

D.

tltoulson · ‎03-09-2015

Can you please check your Table Rotations module? You should see sysevent in the Table Rotations. Database views can not be created on Rotated tables and this is most likely the cause of the problem (Database Views - ServiceNow Wiki). Additionally, Database Views can not include Extended tables either.

View solution in original post

gyedwab · ‎03-09-2015

Try: https://share.servicenow.com/app.do#/detailV2/40b247a787e291008bf84b0b0e434d51/overview

gyedwab · ‎03-09-2015

Like Travis, long posts are being blocked. It's an update set that logs each login on a table that has a reference to the user, for reporting purposes.

dickhirsch · ‎03-09-2015

I remember looking at this recently. Now, I know why you had to build a separate table to hold the login data.

D.

gyedwab · ‎03-10-2015

I can see why ServiceNow didn't want to put a reference field on their sysevent table, but dot-walking is so important! For example, here's an Explore Analytics map report of logins... gives you a whole new world of information.