ConnectWise Ticket Assistant

I do not recall, which server is the Automate DB hosted on?

I would envision something more along the lines of this but would need to test it. The Exists statement I believe would never return anything because you are selecting NULL

SELECT DISTINCT computerid
FROM software s
WHERE s.NAME LIKE 'Screenconnect Client \(%\)'
AND LENGTH\(NULLIF\(MID\(s.NAME,INSTR\(s.NAME,'\('\)+1,16\),''\)\) = 16
AND NULLIF\(MID\(s.NAME,INSTR\(s.NAME,'\('\)+1,16\),''\) IS NOT NULL
AND NOT EXISTS \(
select top 1 1
from v\_extradataclients v
join computers c on c.clientid=v.clientid
where s.computerid = c.computerid
and MID\(s.NAME,INSTR\(s.NAME,'\('\)+1,16\) = v.allowed\_cws\_instances
\)

Derrick Page
Chief Operations Officer
![\[image\]](https://na.myconnectwise.net/v4_6_release/api/inlineimages/labtechx/13a30824-014d-4f17-8e8f-02a44b751dfa) **[305-310-2444**    ](tel:305-310-2444)\[image\] **[786-628-2550](http://fax:786-628-2550)**
![\[image\]](https://na.myconnectwise.net/v4_6_release/api/inlineimages/labtechx/e1fab0e0-de60-4854-86e6-dda575bd9f45) **[[email protected]**    ](mailto:[email protected])\[image\]