Query Management

= General =

The Query Management is the central point for organising queries. Queries are the building blocks for many continuing actions that you can start in ACMP. You can use the queries to call up the data from other modules, which are summarised in the Query Results. Provided that the user has the appropriate permissions, the Query Management is always freely accessible, either via the navigation or via the ribbon bar under the //Query Actions// tab. Here you can display all the data that has been inventoried and also narrow it down using a filter.

6

7

8

[[image:66_Abfrageverwaltung_Übersicht_1280.png||data-xwiki-image-style-alignment="center"]]

Query Management

== Working with Queries ==

16

17

The ribbon bar allows you to [[add>>doc:.Abfragen erstellen.WebHome]] ([[image:Abfrage neu hinzufügen Icon.png||height="17" width="18"]]), [[execute>>doc:.Abfragen ausführen.WebHome]] ([[image:Abfragen ausführen Icon.png||height="17" width="18"]]), edit ([[image:Abfrage bearbeiten.png||height="18" width="18"]]) or delete ([[image:Abfrage löschen.png||height="18" width="18"]]) Queries.

18

19

In addition, you can organise your queries in a folder structure to help you keep track of them. Query Management has a structured design. You will find all the queries created in alphabetical order directly in the overview, along with an optional description and the query basis.

20

21

A number of queries are already provided for you to use during the initial installation. It is also possible to create your own queries and execute them in the Console. To execute a Query, select it and click on //Execute// or start it directly by double-clicking. The tabular results are displayed in the integrated section of the console. In the case of a 1:n relation, the dates are generated and displayed in a sub-query. You can recognise such a sub-query by the icon ([[image:Abfrage Aufklappen Icon.png]]).

22

23

There are basic and advanced queries that you can create. [[Advanced Queries>>doc:.Abfragen erstellen.Erweiterte Abfragen erstellen.WebHome]] allow you to perform more complex queries or filtering.

24

25

The Clients included in the results set of a Query have different icons. This allows you to see how the corresponding Client was inventoried:

26

27

(% style="width:828px" %)

28

|(% style="width:110px" %)**Inventoried Client type**|(% style="width:698px" %)**Description**

29

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypeservice.png||alt="ClientTypeService" height="32" width="32"]]|(% style="width:698px" %)The Client was inventoried by the [[ACMP Agent>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.ACMP Agenten installieren.WebHome]]

30

|(% style="width:110px" %)[[image:ACMP.63.ACMP-Solutions.Client-Management.Abfrageverwaltung.Abfragen auswerten.WebHome@platform_windows.png||alt="ClientTypeOSC" height="32" width="32"]]|(% style="width:698px" %)The Client was inventoried by the [[OneScanClient >>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.OneScanClient.WebHome]]

31

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypead_small.png||alt="ClientTypeAD" height="32" width="32"]]|(% style="width:698px" %)Client was detected by [[Agentless Scanner>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.Agentless Scanner.WebHome]]

32

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemanualclient_small.png||alt="ClientTypeManualClient" height="32" width="32"]]|(% style="width:698px" %)The Client was entered [[manually>>doc:ACMP.67.ACMP-Solutions.Client-Management.Manuelle Clients.WebHome]]

33

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@oslinux.png||alt="OSLinux" height="32" width="32"]]|(% style="width:698px" %)Client was inventoried via [[XML Importer>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.XML Importer.WebHome]] (Linux) or via Linux Unit Agent

34

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@osmac.png||alt="OSMac" height="32" width="32"]]|(% style="width:698px" %)Client was inventoried via [[XML Importer>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.XML Importer.WebHome]] (Mac) or via Linux Unit Agent

35

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@client_networkboot.png||alt="Client_NetworkBoot" height="32" width="32"]]|(% style="width:698px" %)The Client was detected using the [[Network Boot Service>>doc:ACMP.67.ACMP-Solutions.OS Deployment.Network Boot Service.WebHome]]

36

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemobileclientandroid.png||alt="ClientTypeMobileClientAndroid" height="32" width="32"]]|(% style="width:698px" %)It is a mobile Android Client

37

|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemobileclientios.png||alt="ClientTypeMobileClientiOS" height="32" width="32"]]|(% style="width:698px" %)This is a mobile iOS Client

38

|(% style="width:110px" %)[[image:Windows Mobile Client Icon.png||height="32" width="32"]]|(% style="width:698px" %)This is a Windows Mobile Client (Smartphone OS)

39

40

41

In addition to the icons for the inventoried client types, a warning triangle icon ([[image:DoppelteClientId Hinweisbox Hintergrund Icon.png||alt="DoppelteClientId.png" height="21" width="22"]]) may also be displayed instead of the client icon.

42

This icon indicates that this is a suspicious client with a duplicate client ID (see also the section [[Special feature: Suspicious clients in the system>>doc:ACMP.67.ACMP-Solutions.Client-Management.Abfrageverwaltung.Abfragen auswerten.WebHome||anchor="HBesonderheit:VerdE4chtigeClientsimSystem"]]).

43

Wiki source code of Abfrageverwaltung

Navigation

author	version	line-number	content
		1	{{aagon.floatingbox/}}
		2
		3	= General =
		4
		5	The Query Management is the central point for organising queries. Queries are the building blocks for many continuing actions that you can start in ACMP. You can use the queries to call up the data from other modules, which are summarised in the Query Results. Provided that the user has the appropriate permissions, the Query Management is always freely accessible, either via the navigation or via the ribbon bar under the //Query Actions// tab. Here you can display all the data that has been inventoried and also narrow it down using a filter.
		6
		7	{{figure}}
		8	[[image:66_Abfrageverwaltung_Übersicht_1280.png\|\|data-xwiki-image-style-alignment="center"]]
		9
		10	{{figureCaption}}
		11	Query Management
		12	{{/figureCaption}}
		13	{{/figure}}
		14
		15	== Working with Queries ==
		16
		17	The ribbon bar allows you to [[add>>doc:.Abfragen erstellen.WebHome]] ([[image:Abfrage neu hinzufügen Icon.png\|\|height="17" width="18"]]), [[execute>>doc:.Abfragen ausführen.WebHome]] ([[image:Abfragen ausführen Icon.png\|\|height="17" width="18"]]), edit ([[image:Abfrage bearbeiten.png\|\|height="18" width="18"]]) or delete ([[image:Abfrage löschen.png\|\|height="18" width="18"]]) Queries.
		18
		19	In addition, you can organise your queries in a folder structure to help you keep track of them. Query Management has a structured design. You will find all the queries created in alphabetical order directly in the overview, along with an optional description and the query basis.
		20
		21	A number of queries are already provided for you to use during the initial installation. It is also possible to create your own queries and execute them in the Console. To execute a Query, select it and click on //Execute// or start it directly by double-clicking. The tabular results are displayed in the integrated section of the console. In the case of a 1:n relation, the dates are generated and displayed in a sub-query. You can recognise such a sub-query by the icon ([[image:Abfrage Aufklappen Icon.png]]).
		22
		23	There are basic and advanced queries that you can create. [[Advanced Queries>>doc:.Abfragen erstellen.Erweiterte Abfragen erstellen.WebHome]] allow you to perform more complex queries or filtering.
		24
		25	The Clients included in the results set of a Query have different icons. This allows you to see how the corresponding Client was inventoried:
		26
		27	(% style="width:828px" %)
		28	\|(% style="width:110px" %)Inventoried Client type\|(% style="width:698px" %)Description
		29	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypeservice.png\|\|alt="ClientTypeService" height="32" width="32"]]\|(% style="width:698px" %)The Client was inventoried by the [[ACMP Agent>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.ACMP Agenten installieren.WebHome]]
		30	\|(% style="width:110px" %)[[image:ACMP.63.ACMP-Solutions.Client-Management.Abfrageverwaltung.Abfragen auswerten.WebHome@platform_windows.png\|\|alt="ClientTypeOSC" height="32" width="32"]]\|(% style="width:698px" %)The Client was inventoried by the [[OneScanClient >>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.OneScanClient.WebHome]]
		31	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypead_small.png\|\|alt="ClientTypeAD" height="32" width="32"]]\|(% style="width:698px" %)Client was detected by [[Agentless Scanner>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.Agentless Scanner.WebHome]]
		32	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemanualclient_small.png\|\|alt="ClientTypeManualClient" height="32" width="32"]]\|(% style="width:698px" %)The Client was entered [[manually>>doc:ACMP.67.ACMP-Solutions.Client-Management.Manuelle Clients.WebHome]]
		33	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@oslinux.png\|\|alt="OSLinux" height="32" width="32"]]\|(% style="width:698px" %)Client was inventoried via [[XML Importer>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.XML Importer.WebHome]] (Linux) or via Linux Unit Agent
		34	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@osmac.png\|\|alt="OSMac" height="32" width="32"]]\|(% style="width:698px" %)Client was inventoried via [[XML Importer>>doc:ACMP.67.Arbeiten mit der ACMP Console.Clients erfassen.XML Importer.WebHome]] (Mac) or via Linux Unit Agent
		35	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@client_networkboot.png\|\|alt="Client_NetworkBoot" height="32" width="32"]]\|(% style="width:698px" %)The Client was detected using the [[Network Boot Service>>doc:ACMP.67.ACMP-Solutions.OS Deployment.Network Boot Service.WebHome]]
		36	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemobileclientandroid.png\|\|alt="ClientTypeMobileClientAndroid" height="32" width="32"]]\|(% style="width:698px" %)It is a mobile Android Client
		37	\|(% style="width:110px" %)[[image:XWiki.Images.WebHome@clienttypemobileclientios.png\|\|alt="ClientTypeMobileClientiOS" height="32" width="32"]]\|(% style="width:698px" %)This is a mobile iOS Client
		38	\|(% style="width:110px" %)[[image:Windows Mobile Client Icon.png\|\|height="32" width="32"]]\|(% style="width:698px" %)This is a Windows Mobile Client (Smartphone OS)
		39
		40	{{aagon.infobox}}
		41	In addition to the icons for the inventoried client types, a warning triangle icon ([[image:DoppelteClientId Hinweisbox Hintergrund Icon.png\|\|alt="DoppelteClientId.png" height="21" width="22"]]) may also be displayed instead of the client icon.
		42	This icon indicates that this is a suspicious client with a duplicate client ID (see also the section [[Special feature: Suspicious clients in the system>>doc:ACMP.67.ACMP-Solutions.Client-Management.Abfrageverwaltung.Abfragen auswerten.WebHome\|\|anchor="HBesonderheit:VerdE4chtigeClientsimSystem"]]).
		43	{{/aagon.infobox}}