The most recent content from our members.
When I run a sql query the Time colum brings back a number But in the reports online they are in a datetime format How do I get the Number into a datetime via SQL? eg 1339405591826 To 06/11/2012 11:06:31
So, I'm trying to figure out why my Orion install is basically unstable. In the process of tuning a million things I'm trying to set up custom views for individual sub-organizations at my company. I've created a page that has: All Groups component All Nodes - Tree Active Group Alerts Groups with Problems Interfaces with…
I need to customize the Patch Manager "Vulnerable Machines" Orion query into two queries, one for servers and one for workstations, and I also need to limit each to showing machines having >0 outstanding patches. I wouldn't mind including some other counts (patches downloaded, patches pending reboot, etc.) in the same or…
Hi I'm doing a piece of work that is to enable the use of DRS/DPM within or environment. I can run SQL scripts to update the main nodes details, but I have notices that in VIM_Hosts there are other pieces of information I would like to change/ update with the SQL Scripts. namely: What are the allowed values for the above…
_quoMHi All We are currently looking into moving all of our windows monitoring from SNMP to WMI, and in the process we are moving to SAM 5.5 so NIC information is collected via WMI. My question is this, is there some way of listing all of the templates and component monitors that are set to use SNMP. If this is via an SQL…
Hi, I had this topic for one of my Orion Customers and also went through some discussions here in thwack. Finally I managed the task of identifying Trunk vs. Access Ports via Custom Report and manual import of this Report into an Custom Interface Properties column. Motivation: With this combination it is possible to use…
I am a noob in terms of SQL queries. I have been trying to create a report that provides my company's WAN usage per WAN circuit.(With Circuit IDs displayed) I need it to report monthly and I have tried in the 'Advanced SQL' but have been unable to get anthing to Query so that I can at least preview the report before I save…
It looks like you're new here. Sign in or register to get started.