Hi
Where could i get a copy of the ERD for Server Profiler?
thanks
carlos
Hi
Where could i get a copy of the ERD for Server Profiler?
thanks
carlos
Hi Brian
Thanks for the response. I did as you suggested but don't see any SQL statements other than a commented out line pasted below with no other text.
I've attached the report. Could you kindly point to the SQL or where i might be going wrong?
Using IE 7 , Quick Reports -> Storage by Local Share -> Local Shares Assignment
//REPORT QUERY
//
Note in recent versions - 4.12.2 and 4.12.3 I believe - the SQL was hidden by default. I ran the same report as above on 4.12.4, did a view source and the SQL was there:
//REPORT QUERY
//SELECT a.DeviceId, a.DeviceHostName as Field_6069, name as Field_6070, basePath as Field_6071, Level as Field_6072 FROM ent_fa_local_paths_assignment b inner join devices a on a.deviceid = b.deviceid WHERE a.DeviceId IN (.....) AND selected = 1 ORDER BY Field_6069 ASC, Field_6070 ASC limit 0, 251
Where the "..." is a list of deviceid's in your system. You can remove that part of the query (ie "WHERE a.DeviceId IN (.....)") to get everything.
Brian
Go to install/webapps/ROOT/bin
In the server.properities file, add the line
showQueryInReportSource = true
Restart the webserver.
Let me know if that doesn't work.
See KB for more info:
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.