Hi Tim,

It seems that when a computer has manually been set in the past as inactive, SLM has trouble in taking the hand back.

I would reset all clients to "Active" and then start a live daily monitoring to see what happens.

If new computers are wrongly set to "Inactive", then raise a ticket with Support.

Hi,

most likely, thee computers have been set to inactive by the quaratine management in the past, not reporting into SLM / SINV for more then 90 days.

Maybe these computers have been stored somewhere, maybe have been installed and inventoried and then kept in the shelf for more than 90 days - who knows :-)

As soon as a computer has been set to inactive, it will NOT be automatically reactivated whe it continues / restarts to send data to the Inventory Server. The computer will remain in the 'inactive" status for good, not consuming licenses.

I thought, Snow had added a report for this a while ago, but can't find it. There should be an alert or a warning on the Snowboard as well.

Regards

Axel

Hi Samuel,

it looks like the report was more a wish than reality 😭

There must be an alert but I can't see it as well, but an alert "Inactive computers" can be activeted in the user settings.

I'll check, maybe it will require a custom report to achieve this...

Kind regards,

Axel

If someone wants to add this as a custrom report into the SnowLicenseManager database, here is a point to start from (use at own risk, I have just performed a quick test):

DECLARE @NAME                NVARCHAR(MAX) = 'Inactive computers sending data'

declare @cid int = 1

DECLARE @userid int = 0

DECLARE @rid                 uniqueidentifier = (SELECT NEWID())

declare @hostfilter nvarchar(max) = '%'

declare @clienttable table (clientid int)

DECLARE @Description         NVARCHAR(MAX) = 'This report shows Inactive computers that have sent data during the last 90 days'

DECLARE @ColumnList          NVARCHAR(MAX) = ' ComputerID,Hostname,Domain,LastScanDate,StatusCode, Manufacturer, Model, QuarantineDate, QuarantineOverride, Operatingsystem, IPAddress, IsVirtual, UpdatedBy, UpdatedDate'

DECLARE @ColVis              NVARCHAR(MAX) = '0,1,1,1,1,0,0,0,0,0,0,0,0,0'

DECLARE @KeyFieldName        NVARCHAR(MAX) = 'ComputerID'

DECLARE @RowTargetLink       NVARCHAR(MAX) = 'Computer.aspx?id='

DELETE FROM SnowLicenseManager.dbo.tblReport WHERE Name = @NAME

DECLARE @SQL   NVARCHAR(MAX) = 'SELECT       

                        SnowLicenseManager.dbo.tblComputer.ComputerID as ComputerID,

                        SnowLicenseManager.dbo.tblComputer.HostName as HostName,

                        SnowLicenseManager.dbo.tblComputer.Domain As Domain,

                        SnowLicenseManager.dbo.tblComputer.LastScanDate as LastScanDate,

                        SnowLicenseManager.dbo.tblComputerInfo.StatusCode as StatusCode,

                        SnowLicenseManager.dbo.tblComputer.Manufacturer as Manufacturer,

                        SnowLicenseManager.dbo.tblComputer.Model as Model,

                        SnowLicenseManager.dbo.tblComputer.QuarantineDate as QuarantineDate,

                        SnowLicenseManager.dbo.tblComputer.QuarantineOverride as QuarantineOverride,

                        SnowLicenseManager.dbo.tblComputer.OperatingSystem as OperatingSystem,

                        SnowLicenseManager.dbo.tblComputer.IPAddress as IPAddress,

                        SnowLicenseManager.dbo.tblComputer.IsVirtual as IsVirtual,

                        SnowLicenseManager.dbo.tblComputerInfo.UpdatedBy as UpdatedBy,

                        SnowLicenseManager.dbo.tblComputerInfo.UpdatedDate as UpdatedDate

FROM           SnowLicenseManager.dbo.tblComputer INNER JOIN

                        SnowLicenseManager.dbo.tblComputerInfo ON SnowLicenseManager.dbo.tblComputer.CID = SnowLicenseManager.dbo.tblComputerInfo.CID AND

                        SnowLicenseManager.dbo.tblComputer.ComputerID = SnowLicenseManager.dbo.tblComputerInfo.ComputerID

WHERE       (SnowLicenseManager.dbo.tblComputerInfo.StatusCode = 2) AND (SnowLicenseManager.dbo.tblComputer.LastScanDate > DATEADD (d, -90, GETDATE()))'

INSERT INTO SnowLicenseManager.dbo.tblReport (ReportID, StockReport, IsCustomReport, ReportType, ViewName, Name, Description, SQLQuery, ColumnList, ColumnVisibility, KeyFieldName, RowTargetLink, UsesCustomFields, CustomFieldCategoryID)

VALUES (@rid, 0, 1, 3 , 'PROCEDURE', @NAME, @Description, @SQL, @ColumnList, @ColVis, @KeyFieldName, @RowTargetLink, 1, 1)

INSERT INTO SnowLicenseManager.dbo.tblreportsecurity

SELECT ReportID, 0 FROM SnowLicenseManager.dbo.tblReport WHERE ReportID = @rid

At a first glance it makes it a little bit confusing having a an asset which is inactive but scanned some days before. But it makes it comprehensible not to change the status (and last "updated by") even this asset is still running.

@Axel Lamparth​ Thank you for your SQL query this saves a lot of time.