Account list report

This should take care of your request. You'll want to use this in a Custom Query Resource, and those can be added in web reports as well if you want to export the results.

Query (in SWQL):

SELECT
AccountID AS [NAME]
,CASE
  WHEN AccountType = 0 THEN 'Orion Service Account'
  WHEN AccountType = 1 THEN 'Local Orion'
  WHEN AccountType = 2 THEN 'AD Individual'
  WHEN AccountType = 3 THEN 'AD Group'
  WHEN AccountType = 4 THEN 'Group Member'
END AS [ACCOUNT TYPE]
,CASE
  WHEN AccountType IN ('0','1') THEN '/Orion/Admin/Accounts/images/icons/orion_generic_icon_orange.gif'
  ELSE '/Orion/Admin/Accounts/images/icons/windows.gif'
END AS [_IconFor_ACCOUNT TYPE]
,CASE
  WHEN Enabled = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ENABLED]
,CASE
  WHEN Enabled = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ENABLED]
,Expires AS [EXPIRATION]
,LastLogin AS [LAST LOGIN]
,CASE
  WHEN LimitationID1 IS NULL OR LimitationID1 = '0' THEN 'None'
  WHEN LimitationID2 IS NULL OR LimitationID2 = '0' THEN 'None'
  WHEN LimitationID3 IS NULL OR LimitationID3 = '0' THEN 'None'
  ELSE 'Limitations Exist'
END AS [ACCOUNT LIMITAITON]
,CASE
  WHEN AllowAdmin = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ADMIN RIGHTS]
,CASE
  WHEN AllowAdmin = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ADMIN RIGHTS]
,CASE
  WHEN AllowNodeManagement = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [NODE MGMT]
,CASE
  WHEN AllowNodeManagement = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_NODE MGMT]
,CASE
  WHEN AllowReportManagement = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [REPORT MGMT]
,CASE
  WHEN AllowReportManagement = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_REPORT MGMT]
,CASE
  WHEN AllowAlertManagement = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ALERT MGMT]
,CASE
  WHEN AllowAlertManagement = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ALERT MGMT]
,CASE
  WHEN AllowUnmanage = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ALLOW UNMANAGE]
,CASE
  WHEN AllowUnmanage = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ALLOW UNMANAGE]
,CASE
  WHEN AllowDisableAction = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ALLOW DISABLE ACTIONS]
,CASE
  WHEN AllowDisableAction = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ALLOW DISABLE ACTIONS]
,CASE
  WHEN AllowDisableAlert = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ALLOW DISABLE ALERTS]
,CASE
  WHEN AllowDisableAlert = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ALLOW DISABLE ALERTS]
,CASE
  WHEN AllowDisableAllActions = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [ALLOW DISABLE ALL ACTIONS]
,CASE
  WHEN AllowDisableAllActions = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_ALLOW DISABLE ALL ACTIONS]
,CASE
  WHEN AllowCustomize = 'Y' THEN 'Yes'
  ELSE 'No'
END AS [view]
,CASE
  WHEN AllowCustomize = 'Y' THEN '/Orion/Admin/Accounts/images/icons/ok_enabled.png'
  ELSE '/Orion/Admin/Accounts/images/icons/disable.png'
END AS [_IconFor_VIEW CUSTOMIZATIONS]
FROM Orion.Accounts
WHERE AccountType IN ('1','2','3')
--AND AccountID LIKE '%${SEARCH_STRING}%'
ORDER BY AccountType, AccountID

Notice Line 104 is commented out. You can remove this if you want your resource to be searchable by Account Name (remove the '--' from the beginning of the line)

This is what the end result looks like:

Hope that helps!

Thanks Zack that is precisely what I needed. My Boss and I are very appreciative.

Jeff

zackm​

I followed you in to San Mateo. Great Report!!!! Hope you are enjoying Cardinal.

zackm​,

I'm having some trouble getting this to display in a report. When I drop this into the content popup of a custom table and test it, the data shows up.

When I add it to the layout and preview the report, it comes up blank.

Any idea why this is occurring?

no idea; it was designed for a custom query resource, but my assumption is it would have worked with a custom table as well. (especially if it previews correctly in the datasource)

You need to add the selected fields in the Layout view.

Thanks that was it!

Hey Zack

This is perfect for what my manager has asked me to do,

I have 1 issue though,

why isn't my icon for Account type showing?

Thanks in advance

AJ

Did you use a Custom Table or a Custom Query? - This was written to be used in a Custom Query.

That's solved it,

thanks so much for your quick reply David.