Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

CREATE DB VIEW FILTERED FOR SYS_USER_GRMEMBER AND CMDB_REL_CI TABLENAME

Randy TCTS
Tera Expert

3 weeks ago

Hi.  I am working on creating a database view from the sys_audit_delete table showing only data where the tablename is sys_user_grmember or cmdb_rel_ci.

 

I had the following conditions attempted in the where clause and they both does not apply the filter when trying out the view.  I also tried the business rule route and that did not work as well.  I am hoping to get some guidance as custom table and report solutions are out of the question.  Thank you for your help.

 

1. where clause field "viewprefix_tablename='sys_user_grmember'^ORviewprefix_tablename='cmdb_rel_ci'"

2. where clause field "viewprefix.tablename='sys_user_grmember'^ORviewprefix.tablename='cmdb_rel_ci'"

 

@tangcov 

Labels:
0 Helpfuls
  • 502 Views
1 REPLY 1

Mark Manders
Giga Patron

3 weeks ago

Be aware that the Community guidelines don't allow posting the same question in multiple forums. 
https://www.servicenow.com/community/servicenow-ai-platform-forum/creating-a-database-view-from-sys-...


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls