Check Skype for Business or Lync or OCS presence in SQL

User strored procedure

dbo.DiagShowPublisherPresence
in RTCLOCAL SQL copy on each FrontEnd (not SBA)

http://mikestacy.typepad.com/mike-stacys-blog/sql/