Troubleshooting

Troubleshooting Software Distribution Agent

UEM Database Query
				
					SELECT * FROM BlobMaster
INNER JOIN deviceApplication.Application
ON blobID = BinaryBlobID
WHERE PackageID = 'com.airwatch.appdeployment' 
SELECT * FROM BlobMaster
INNER JOIN deviceApplication.Application
ON blobID = BinaryBlobID
WHERE PackageID = 'com.airwatch.windowsprotectionagent'


select version, * from deviceApplication.Application where PackageID = 'com.airwatch.appdeployment'
select version, * from deviceApplication.Application where PackageID = 'com.airwatch.windowsprotectionagent'


--update blobmaster set storageType = 0 where blobID IN (1588, 1589, 1590)

--Update deviceApplication.Application
--Set IsSystemApplication = 0
--Where ApplicationID IN (137, 139, 138)


---

Select version, Name, IsSystemApplication, * from deviceapplication.Application

where PackageID = 'com.airwatch.appdeployment'


Select * from BlobMaster
where BlobID = 592


Update deviceApplication.Application
Set IsSystemApplication = 0 
Where ApplicationID = 137