Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jojo27
Engaged Sweeper

is this possible calling an existing report on the new report I'm doing? I'm not too familiar with SQL and just a slight knowledge of it.

example. 
existing report is all asset that has a specific Account on their system.

new report should be excluding all those assets that is already been on the existing report.

Any help is appreciated.

1 REPLY 1
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@Jojo27 

 

This can be done using subqueries.  

 

eg. 

Use the first query and slim it down to only the record ID's and use that query as a subquery to exclude these record ID's  in your final query.

 

SQL Subqueries - w3resource

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now