Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have a SQL Table audit and would like to use the Company ID or Company Name to create SmartList reports per company. How can I do this?

April 26, 2017audit COMPANY create Id reports smartlist sql Table

0

Posted

I have a SQL Table audit and would like to use the Company ID or Company Name to create SmartList reports per company. How can I do this?

1 Answer

0

Posted

SQL Table audits do not use the Company ID or Company Name fields. Instead, they use the Product Name column to store the Database name. Recommendation: To get a report on the Company, use the Product Name field and display the appropriate Company Name depending upon what the database is.