Sql Query on workstations.

Cary Miller 1

Here is my scenario. I have a SQL database that has a list of when users logged off of a virtual machine.
I want to run a sql query that looks at name field, an event type field and have it look at a selection of time. If it does not find a event type that matches within a certain time field, it will report back the name.

What I have so far.
Select *
from vim_events.dbo.event.historical
where moduleandeventtext like '%machinename%' and eventtype like '%agent_ended%' and time>=convert(datetime, '2021-08-18')

it will spit back a report of Agent_ended queries that exist after 08/18/2021, but I need it to spit out a list of workstations that don't have an agent_ended after that date.

Erland Sommarskog 101.4K Reputation points MVP

2021-10-18T21:50:36.837+00:00

We don't know your tables, so need to get information about them to be able to help you. The recommended approach is that you post CREATE TABLE statements your table(s) and INSERT statements with sample data, and the desired result given the sample.
EchoLiu-MSFT 14,571 Reputation points

2021-10-19T07:55:38.94+00:00

Hi @Cary Miller ，

Welcome to the microsoft TSQL Q&A forum!
Could you please share us your table structure (CREATE TABLE …) and some sample data(INSERT INTO …)along with your expected result? So that we’ll get a right direction and make some test.

Regards
Echo