Domain report...

[pentel]

Hi,

Would it be possible to give me the query that generates the view for web30totaldomain? I tried to get it to show in the report builder by renaming it to web30reptotaldomain, but that failed. The thing I would like to do is subdivide this view since we only have 1 domain, but multiple offices. By editing and adding more filtering options to this view I can get exactly what I need.

If the above is not possible, could I get a few values that can generate a similar report? I can go build it from scratch if I have at least these (I've been looking for the last hour or so with no success and need to go on to other things as well).

Thanks

[pentel]

Hi,

With the help of CTRL+F I found some leads that should eventually help me do what I'm looking to do.

Thanks for mentioning the SQL scripts were there!

[Hemoco]

Take a look in your %programfiles%\lansweeper\sql script folder
Here are all the scripts used in the database.