Abfrage Software Installationen Operator "Not Like"

[Stefan.Wilp]

Hallo,

ich versuche eine Abfrage zu erstellen per SQL:

Select SYS_SW_SETUP.NAME,
Count(CLT_CLIENTS.COMPUTERNAME) As Anzahl
From CLT_SW_SETUP
Inner Join CLT_CLIENTS On CLT_SW_SETUP.CLIENTID = CLT_CLIENTS.CLIENTID
Inner Join SYS_SW_SETUP On CLT_SW_SETUP.SWSETUPID = SYS_SW_SETUP.SWSETUPID
Inner Join CLT_ContainerPath On CLT_CLIENTS.CLIENTID =
CLT_ContainerPath.ClientID
Where CLT_ContainerPath.CPath Like '%PCs\Amt 45\Schulen_Jugend%'
Group By SYS_SW_SETUP.NAME
Having (SYS_SW_SETUP.NAME Like '%Office Prof%16%') Or
(SYS_SW_SETUP.NAME Like '%Office Standard%16%') Or
(SYS_SW_SETUP.NAME Like '%Office Standard%2010%') Or
(SYS_SW_SETUP.NAME Like '%Office Prof%2010%') Or
(SYS_SW_SETUP.NAME Like '%Office Prof%2003%') Or
(SYS_SW_SETUP.NAME Like '%Office Stand%2003%')

Ergebnis:

like.PNG (6.72 KiB) 3175 mal betrachtet

In der Zeile wird "not Like" nicht akzeptiert, hat keinen Effekt.

Where CLT_ContainerPath.CPath Like '%PCs\Amt 45\Schulen_Jugend%'

notlike.PNG (10.22 KiB) 3175 mal betrachtet

Hat jemand dazu vielleicht eine Idee?

Ich habe es per Assistent und SQL Select versucht.

Ich möchte automatisch Reports zum Stand des Rollouts von Office versenden.

Gruß

[Stefan.Wilp]

Hat sich erledigt.....war ein fehler in der Abfrage:

Select SYS_SW_SETUP.NAME,
Count(CLT_CLIENTS.COMPUTERNAME) As Anzahl
From CLT_SW_SETUP
Inner Join CLT_CLIENTS On CLT_SW_SETUP.CLIENTID = CLT_CLIENTS.CLIENTID
Inner Join SYS_SW_SETUP On CLT_SW_SETUP.SWSETUPID = SYS_SW_SETUP.SWSETUPID
Inner Join CLT_ContainerPath On CLT_CLIENTS.CLIENTID =
CLT_ContainerPath.ClientID
Where (CLT_ContainerPath.CPath not Like '%PCs\Amt 45\Schulen_Jugend%' and
CLT_ContainerPath.CPath not Like '%PCs\Amt 45\KiTas%' and
CLT_ContainerPath.CPath not Like '%PCs\Amt 45\VHS%' and
CLT_ContainerPath.CPath not Like '%Standorte\Bücherei%' and
CLT_ContainerPath.CPath not Like '%Standorte\%Museum%')
and CLT_ContainerPath.CPath Like '%PCs\%'
Group By SYS_SW_SETUP.NAME
Having (SYS_SW_SETUP.NAME Like '%Office Prof%16%') or
(SYS_SW_SETUP.NAME Like '%Office Standard%16%') or
(SYS_SW_SETUP.NAME Like '%Office Standard%2010%') or
(SYS_SW_SETUP.NAME Like '%Office Prof%2010%') Or
(SYS_SW_SETUP.NAME Like '%Office Prof%2003%') Or
(SYS_SW_SETUP.NAME Like '%Office Stand%2003%')


Das "and" war entscheidend:

Where (CLT_ContainerPath.CPath not Like '%PCs\Amt 45\Schulen_Jugend%' and
CLT_ContainerPath.CPath not Like '%PCs\Amt 45\KiTas%' and
CLT_ContainerPath.CPath not Like '%PCs\Amt 45\VHS%' and
CLT_ContainerPath.CPath not Like '%Standorte\Bücherei%' and
CLT_ContainerPath.CPath not Like '%Standorte\%Museum%')
and CLT_ContainerPath.CPath Like '%PCs\%'