I have filters in some reports but doesn't seem to work.I don't need to know if a user has not logged in for thirty days if his account is not enabled. tblADusers.IsEnabled = 'True'
Hi Guy's I have a report as per below.Its a battery life report etc. I am wanting to calculate the battery life, for example 44004 is the Design Capacity, Warranty terms are 25% of the batter per year etc, I was wanting to see if there is a way to c...
Hello!We have several AD groups, of which all Windows machines on the domain should be a member of one of them. Ideally, I'd like a report that lists all Windows machines that are in a number of those groups not equal to 1.Let's say that the group na...
Hello,I need to deploy software to each User in an AD security group. I have a report of those users, but I need the primary computers they logon to in order to deploy the software. Can maybe do a logon count of >10 to return that primary computer ...
There is a solved question for creating a report for finding a specific Windows Update but it is for the older version of Lansweeper. SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Descriptio...
Has anyone created a report to get all the software and Hardware (including pc and monitor)? I have been looking and have not had any luck. I would like it to list the PC name, username, IP, monitors attached, printer if attached and all software i...
I'm still fairly new to SQL. Through lots of trial and error I was able to come up with the following 2 reports. I'm trying to merge them but am having difficulty. This is the Registry report I want to combine with a Software report: Select Top 1000...
