Database view using sysevent table

[dickhirsch]

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 · Accepted solution]

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.

[tltoulson]

Database Views - ServiceNow Wiki

[tltoulson]

Sorry for breaking it up like this, I have been getting errors that prevented me from posting, so I did everything I could to get the post to go through.   So hopefully this helps 😄

[dickhirsch]

I checked and you're right - sysevent is listed in our Table Rotation module.

Database views can not be created on tables that participate in Table Rotation.

Thanks for the tip regarding the right spot in the wiki

I'll have to look to another way to solve my problem. .

D.