Report Generation- How to generate a report for inactive users in a particular period.

Question

Hello All, 
 I need to generate a report for inactive users who were inactivated in a particular period. I am using version 7. 
 Please let me know how to proceed this?

Markus Weiss-Ehlers · Answer

As written in my other reply, if you have TimeTrace activated you are able to build a report that is able to fetch the information using historical data queries, even if the historical data has been moved to one of the connected historical databases. 
 If your historical data for the range in question is still in the main database and the persons have not been deleted yet you can retrieve the information with the following query. 
 select P.LastName, P.FirstName, P.CentralAccount, q.OperationDate as DisabledDate
from 
QBMWatchOperationSummary q
join Person p on q.ObjectKeyOfRow = p.XObjectKey and q.TableName='Person'
where 
q.ColumnName = 'IsInactive'
and q.ContentShort = '1'
and q.OperationDate >= '2017-01-01' 
and q.OperationDate < '2017-06-01'