The CreatorCon Call for Content is officially open! Get started here.

Database View with Script Includes

shellypoeckes
Tera Contributor

Hi All,

 

Is it possible to call a script includes like report below in a database view?  I have a complex script include that returns the sys ids of servers.  Would like to create a database view and then create different reports to run against that view.

find_real_file.png

Here's the database view. How would I code the where clause like above in report?

find_real_file.png

1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

You can't call script include from where clause since where clause supports only below characters in database view

 

=, !=, <, <=, >, >=, &&, ||

 

In your case, you will need to use performance analytics to filter out data using breakdowns.

If you don't have PA, then UI page will work for you to pull data from different tables.

 

Regards,

Sachin