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 ...
I'm looking for a config for a dynamic group or a report I can run to update Edge weekly or whenever a Zero Day Vulnerability comes out. Just something I can change the version on and add an installer to upgrade Edge as I need to.Thanks!
Generate SQL queries to recreate your custom reports on another database. This code is designed for SQL Server and will not work on SQL Compact.SELECT 'INSERT INTO [tsysreports] ([Reportquery] ,[Reporttitle] ,[Sendmail] ,[Mailgrou...
Dear Lansweeper community,I am trying to write a report to list every computer and it's specific AD group membership. I want to use STUFF to join all AD groups containing *ROLE* into a single column. In our environment, almost every computer is mem...
Hello everyone,I can't seem to figure out where to find the "comments" field from an asset's edit page in the report builder.I've seen results online for adding comments from the "comments tab" of an asset. But I am looking for the "comments" field w...
Hi team, I'm just reaching out to see if anyone has coded a report for Lenovo warranty start AND expiration dates! Trying to start a Warranty Refresh program and replace devices 5 years after their warranty started.Thanks!
I have managed to get a report put together that Reports on all systems in my Inventory that have a Certain SSL Certificate installed. Using the GetDate() Function, I can report on systems that have an expired certificate that expired prior to the c...
Due to eClinicalWorks updates installing over each other, running a normal "software" report will not do the job.The example below as to why in my experience it is difficult to write a normal software installation report for the software. As you can ...
