Customer receives an error that there is a lock on a line item on the Equipment page. This query will show which account(s) has this issue.
Run the below query in SQL /****** Script for SelectTopNRows command from SSMS ******/SELECT TOP (1000)[Locked],[AccountID],[DisplayOrder],[PartNumber],[Description],[Quantity],[Location],[InstallDate],[PartExpirationDate],[LaborExpirationDate],[Installer],[OptionInfo],[Zone],[Sort1],[Sort2],[Sort3],[Sort4],[Sort5],[SIMSUser],[Computer],[DateTimeStamp]FROM [SIMSData].[dbo].[AccountEquipment] Where Locked = '1'
