MFP data output from DB Query

Document ID : KB000107557
Last Modified Date : 23/07/2018
Show Technical Document Details
Question:
We would need to extract MFP data from any given Device ID or User ID.
Answer:
[A] Query to get device signatures associated to a user 

select devicesignature from arrfdeviceinfo where deviceidseqid in (select deviceidseqid from arrfdevuserasso where username='<username in capital letter>'); 

For example: 
select devicesignature from arrfdeviceinfo where deviceidseqid in (select deviceidseqid from arrfdevuserasso where username='TEST'); 

[B] Query to get device signatures associated to a device id 

select devicesignature from arrfdeviceinfo where deviceid='device id'; 

For example: 
select devicesignature from arrfdeviceinfo where deviceid='r5phe+9SpnI13Zgg2idMeeYrpdlrYEYtoFjA67zBk/IlXxhwbdrkzA==';