Skip to content

Commit c5031ca

Browse files
1homas1homas
committed
Removed _table from filename
1 parent b40640a commit c5031ca

75 files changed

Lines changed: 755 additions & 611 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎data/SQL/aaa_diagnostics_view.sql‎

Lines changed: 22 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,22 @@
1+
--
2+
-- ISE Reports > Diagnostics > AAA Diagnostics
3+
--
4+
-- 💡 Un/Comment columns to quickly customize queries. Remember the last SELECT column must not end with a `,`.
5+
--
6+
7+
SELECT
8+
* -- all columns
9+
-- timestamp_timezone,
10+
-- TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') AS timestamp, -- drop fractional seconds
11+
-- session_id,
12+
-- ise_node,
13+
-- username,
14+
-- message_severity,
15+
-- message_code,
16+
-- message_text,
17+
-- category,
18+
-- info
19+
FROM aaa_diagnostics_view
20+
-- ORDER BY timestamp ASC -- first/oldest records
21+
ORDER BY timestamp DESC -- most recent records
22+
FETCH FIRST 100 ROWS ONLY -- limit default number of rows returned for large datasets

‎data/SQL/aaa_diagnostics_view_table.sql‎

Lines changed: 0 additions & 14 deletions
This file was deleted.

‎data/SQL/admin_users.sql‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
--
2+
-- admin_users
3+
--
4+
-- 💡 Un/Comment columns to quickly customize queries. Remember the last SELECT column must not end with a `,`.
5+
--
6+
7+
SELECT
8+
* -- all columns
9+
FROM admin_users
10+
FETCH FIRST 10 ROWS ONLY -- limit default number of rows returned for large datasets

‎data/SQL/admin_users_table.sql‎

Lines changed: 0 additions & 3 deletions
This file was deleted.

‎data/SQL/administrator_logins.sql‎

Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
--
2+
-- administrator_logins
3+
--
4+
-- 💡 Un/Comment columns to quickly customize queries. Remember the last SELECT column must not end with a `,`.
5+
--
6+
7+
SELECT
8+
-- * -- all columns
9+
TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') AS timestamp, -- drop fractional seconds
10+
ip_address, -- comment
11+
admin_name, -- comment
12+
admin_session, -- [AdminGUI_Session, ?]
13+
CASE WHEN LENGTH(event_details) > 40 THEN SUBSTR(event_details, 1, 39) || '...' ELSE event_details END AS event_details, -- trim verbose messages
14+
-- event_details, -- comment
15+
event -- comment
16+
-- timestamp_timezone, -- comment
17+
-- ise_node, -- comment
18+
-- ipv6_address, -- comment
19+
-- interface, -- [GUI, ERS]
20+
FROM administrator_logins
21+
-- ORDER BY timestamp ASC
22+
WHERE admin_name = 'readonly'
23+
-- WHERE admin_name = 'iseadamin'
24+
ORDER BY timestamp ASC -- first/oldest records
25+
-- ORDER BY timestamp DESC -- most recent records
26+
FETCH FIRST 100 ROWS ONLY -- limit default number of rows returned for large datasets

‎data/SQL/administrator_logins_table.sql‎

Lines changed: 0 additions & 3 deletions
This file was deleted.

data/SQL/endpoint_identity_groups_table.sql renamed to data/SQL/endpoint_identity_groups.sql

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,9 @@
1-
SELECT * --
1+
--
2+
-- endpoint_identity_groups
3+
--
4+
5+
SELECT
6+
* --
27
-- id
38
-- name
49
-- description
@@ -7,4 +12,4 @@ SELECT * --
712
-- update_time
813
-- status
914
FROM endpoint_identity_groups --
10-
-- FETCH FIRST 10 ROWS ONLY
15+
FETCH FIRST 10 ROWS ONLY -- limit default number of rows returned for large datasets

‎data/SQL/endpoint_purge_view.sql‎

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,7 @@
1+
--
2+
-- endpoint_purge_view
3+
--
4+
15
SELECT id,
26
endpoint_purge_id,
37
run_time,
@@ -7,4 +11,4 @@ SELECT id,
711
endpoint_count
812
FROM endpoint_purge_view
913
ORDER BY endpoint_purge_id
10-
-- FETCH FIRST 10 ROWS ONLY
14+
FETCH FIRST 10 ROWS ONLY -- limit default number of rows returned for large datasets

‎data/SQL/endpoint_purge_view_table.sql‎

Lines changed: 0 additions & 11 deletions
This file was deleted.

‎data/SQL/endpoints_data.sql‎

Lines changed: 8 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,16 @@
1+
--
2+
-- endpoints_data
3+
--
4+
15
SELECT
26
mac_address,
37
endpoint_ip,
4-
endpoint_policy,
8+
endpoint_policy, -- endpoint profile classification
59
static_group_assignment,
610
matched_value, -- Matched Certainty Factor
711
custom_attributes,
812
hostname,
9-
id,
13+
-- id,
1014
static_assignment,
1115
-- reg_timestamp, -- 🐞 Always 0?
1216
-- auth_store_id, -- Always blank?
@@ -32,4 +36,5 @@ SELECT
3236
-- unique_subject_id,
3337
version
3438
FROM endpoints_data
35-
-- FETCH FIRST 10 ROWS ONLY
39+
ORDER BY mac_address ASC
40+
FETCH FIRST 10 ROWS ONLY -- limit default number of rows returned for large datasets

0 commit comments

Comments
 (0)