How many people have what roles?
I'm trying to determine how many people have a given role. For example, how many people have the SDAdmin role in my instance of SDP. So far I've built this: SELECT * FROM AaaAuthorizedRole aar LEFT JOIN AaaRole ON aar.ROLE_ID=aaarole.ROLE_ID LEFT JOIN AaaUser aau on aar.ACCOUNT_ID=aau.USER_ID WHERE AaaRole.NAME='SDAdmin' But the problem is, the results don't list my user account which I know for sure has SDAdmin rights. Am I looking at the wrong table? Is there another table that deals with Technician
schema definition
Version: 7.6.0 Build 7605 Hi All, I recently learned about the Report > New Query Report functionality. Very useful. Is there a published schema definition to assist in writing custom queries? Thanks, Stefan
MS SQL Schema Map?
Has anyone mapped out the full Schema of SDP 7.6 in MS SQL? This would be incredibly useful for generating my own reports. At the moment, I'm trying to track down the creator of a Change ticket (different from the Requester and Technician.) Thanks!
Adding Requester Name to PO Reports
So I'm trying to create a report for POs that specifies a Requester. So I only want to see POs requested by Joe Schmoe. Now, to test out the column of "Requester", I did the following: SELECT pos.STATUSNAME "PO Status",po.POCUSTOMID "PO Number",po.PONAME "PO Name",longtodate(po.DATEORDERED) "Ordered Date",longtodate(po.DATEREQUIRED) "Required Date",pos.STATUSNAME "PO Status",poa.FIRST_NAME "Requester", paao.NAME "Vendor Name",po.TOTALPRICE "Total Price" FROM PurchaseOrder po LEFT JOIN POStatus
Not showing all routers in the 'Set SNMP' menu
Hello We have Netflow Analyser 8 Professional running and we have SNMP access to all our routers. When I try to get Netflow to retrieve the interface descirptions via the ' Set SNMP' option, it doesn't show all the routers in the list. However it does know about all the routers as they all show up in the All devices list but some of them without the interface desciptions. I have tried to run the SNMP retrieve for all routers but this doesn't work either. We have checked that the routers
Opmanager Monitoring issues
We are having troubles with monitoring Interface details on Windows Server 2008 systems that run on a XEN host. We have them set up with the Citrix PV driver for their network, and can view live data, but all of the Win 2K8 servers lack any data in the "Traffic - Today", "Errors and Discards - Today" et al graphs from the Interface details. We have Win 2K3 servers running on the same XEN hosts with the Citrix PV driver for 2K3, and get graphed data for them. Thanks Jason Meyers
How to reset reset default admin password?
Hi all, Is there a way to reset default passworld for Service desk plus administartor account?
Deleted administrator account - HELP!!!
Dear Support, I have version servicedesk plus 7.6 installed. After an import from AD, I tried to clean up and accidentally deleted the administrator account. I found info on this forum on how to change another user to an admin role but when I execute some of the queries to update role I get this: mysql> update aaaauthorizedrole set role_id=4 where account_id=381; ERROR 1062 (23000): Duplicate entry '381-4' for key 1 Did I miss something? I really hope you can help me! Thanks in advance for
Question about message in log files
Hi mates! I'm testing AppManager and it seems really great. But I have one question, I've configured some Linux and Database Query Monitors and I see a lot of lines of these kind in log files. 20 Sep 2010 18:51:15:921 MEAM: FAULT --> RCAnalyser --> Clear match found for 10037376 and 5006 20 Sep 2010 18:51:15:921 MEAM: FAULT --> RCAnalyser --> Clear match found for 10037378 and 5006 20 Sep 2010 18:51:15:921 MEAM: FAULT --> RCAnalyser --> Clear match found for 10037380 and 5006 20 Sep 2010 18:51:15:921
Graduated Information; Trouble -> Warning -> Critical
Hello, Is it at all possible to have a graduated system where it is possible to define a server to go through a number of steps progressivly changing it's status/colour until it hits the notification. For example: CPU threshold 0-55% = Normal (green) >55-70% = Trouble (yellow) >70%-80% = Warning (orange) >80% = Critical (red); send notification Rather than just having one threshold where the server is fine and then all of a sudden out of no where it is critical as it reaches the threshold
More than 1 email address per requester
Each requester should have the option of having more than one email address per account. For example we have one user who has 3 different email addresses, depending on which office they are working from. At the moment they have to have three different accounts, and as a result can not see all of their incidents under one account, and have to log into each account in turn.
Automate Patch deployment
I have set up a scheduled "Automate Patch Deployment" job on a few desktops to download and deploy missing patches. It just downloaded and finished but nothing was installed. I tried the same job but only for my desktop and this is what I got in e-mail and no patches were installed again. Please help! What am I missing? Task Name : NH-Desktop Task Started at : Fri Oct 01 16:30:00 PDT 2010 Task Completed at : Fri Oct 01 16:30:36 PDT 2010 Patch Scan Status : Patch Download Status : 12 patch(es)
WMI Buffer Cache Hit Ratio not being added
Hello, I am trying to add a new WMI Performance counter to our SQL Server in Opmanager. There is no counter added after selecting Add WMI Monitor -> SQLServer:Buffer Manager -> then putting a check/tick in Buffer Cache Hit Ratio -> then clicking on OK My WMI/SNMP credentials are all setup well, and all pass the 'test'. Any ideas as to why this is not working? Thanks and regards Troy
Where do you get your device graphics from?
Hi All I have seen some very fine network diagrams and rack diagrams from users of OpManager, could you tell me where you got your graphics (png or jpg) files from. I have Visio with all the Del and HPl graphics and Rack graphics but I can't find anywhere that does them in jpg format? Thanks in advance for any info. Eric
Alert for Non-Empty Results with MySQL DB Query
Hi, We have the following threshold that I applied to a MySQL DB Query, which I tried to alert me should the query not be empty (it would return one of several dozen values): Alas using '*' as a wildcard doesn't work. Does anyone have a suggestions to do wildcard searches or maybe a way to check if a result is not empty? Thanks!
SQl and Exchange dashboards
according to a recent webinar i viewed, we are able to view sql and exchange dashboards. I have added all the moniotrs but where do i see the sql dashboards?
Opmanager Installation Enhancements
Hi A couple of observations from our recent installation of Opmanager. Would it be possible to add the following options to the installation process: 1. Select the Installation location of the Database and Opmanager application. This way the database can be on a seperate disk to the Opmanager application 2. Ability to decide\select\create an account that will be used to access the Database. 3. The ability to change the Root password to comply with security requirements of an establishment.
Dashboard overview for users that are limited to a business view
Hello guys, Is it possible to give a user that is limited to a business view the Overview dashboard (but only for his devices?) Right now I only have the alarms and the business view but not the cool widgets (top 10, infrastructure snapshot, real traffic, ...) Thanks Thomas
SMS message Alerts for URL Monitoring
Hi, Can i send sms notifications for URLs. As i want to send email alerts also but need to sms as part of critical notifications. Thank you. Regards, Moazzam
How to use SNMPv3 to query for device/interface names?
Hi, I installed Netflow Analyzer (trial version) and am evaluating it for enterprise deployment. I am testing on a Cisco 3845, with x2 gigabit physical interfaces and one ipsec logical tunnel interface (Tunnel1) and one loopback interface (Loopback1). I configured netflow on the router successfully using Loopback1 as the source. Netflow Analyzer is receving the flows and displaying results. However, when i configured the router for netflow, I hadn't yet configured SNMP credentials in Netflow Analyzer,
Opmanager - Folder Monitor, check for Modified time
As the subject line states, am looking for a folder monitor that just checks the modified time. My threshold would be set for older or equal to 2 hours. If items changes within the folder have not taken place within that 2 hour time frame I would configure an alert be sent to application support team. By the way, it was at our application maintenace team's request, that this type of monitoring be used. Currently with opmanager I just can't think of a way to do it. Thank you
Product Import on SupportCenter
How do i import products into the MSSQL database connected to SupportCenter (using excel / CSV etc) i have a List of customers and products that i need to import before using the software. thankyou in advance dwh@tandc.co.uk
Issues with getting Radius working together with a Cisco ACS 4.2 server
Hi all, I am trying to get radius working between Netflow EE 7.5 and ACS 4.2 I have attach screen shots of my configuration. One I have not attached "Allow MS-Chap V1 & 2 Authentication" both are ticked. I am not seeing anything in my logs with ACS, and the authentication is not working. Any ideas where I can start to look for logs / trace to help me find the problem?
Conversation data not show for a time period less than 6 hours
I have an 8.5 installation of net Flow Analyzer and I can't view conversation data with a time period less than 6 hours. I work with an SQLNET db on a remote server. Any idea ? Ciao Fabio.
How to add a router
Can someone please help me to add a router to this program. I tried doing it but after selecting cisco from the device list it add some columns to be filled... i am to recommend this software before we can purchase it for our company... Thanks
Netflow real time / live data
We are evaluating Netflow Analyzer. I am trying to find out if the traffic I am looking at under All Devices -> Interface View is live or real time. Or is it delayed by an hour. Because whenever I look at the time range, the end is always and hour form the current time. This also happens when we drill down into the traffic details. We need to be able to view the traffic as close to real time as possible so that we can rectify any immediate issues. Thanks.
Switchport descriptions and updates
Good evening, I have a Cisco switch with 100 switchports. The description on these ports changes. How can i reindex them to update the description. If i do a rediscovery it does not notice that those ports have changed. Thanks in advance, i am very much looking for a solution. -sean
Business Views Error
Hi, My opmanager has been working fine for some days, until this morning when I have began seeing 'Error' when I try accessing a business view. I have generated and submitted a support information file to support@opmanager.com. I am wondering how long before I get a response? My contact address is felixnkansah@gmail.com Thanks. Felix
This is why Xirrus chose NetFlow Analyzer - A Video Testimonial
ManageEngine NetFlow Analyzer gives amazing level of visibility into network traffic and it is IPAD compatible! - Mike Rydalch, Principal Technologist at Xirrus THANK YOU XIRRUS TEAM NetFlow Team appreciates Aaron Bhaskar of SofSol,NZ and Kumar Natarajan & Bhaskar Sivaprakasam of ManageEngine to get this excellent feedback.
Technician view own requests that they submit
There is a huge problem with tracking requests that are submitted by technicians. I have seen several posts about this but no resolution. Joe is a technician Joe submits a request which is assigned to a different group/department Joe can no longer track or see the request he submitted The answer I was given was to all Joe to view ALL requests or requests in different departments. This violates several business rules and is not satisfactory. The program is already doing "My open requests",
Time spent report
Hello, managers love to know how our time is spent. Here is the criteria Technician Time spent by individual ticket When the ticket was opened and when it was closed (the problem with this one is that a ticket can be resolved and if the user doesn't close it right away it is left open until 5 days pass (our business rule) then it is closed. Therefore it is not really clear how long it took a tech to resolve an issue. Description A weekly report on the previous week (M-F) I use the following columns
Department not visible in self service portal.
Hi, Recently we had implemented Service desk plus 7.6.0 in our organization. We had included user database from our AD. And we had created departments in Organizational details. But it is not visible in self service portal or in requester field. Please do the needful to solve this issue. Thanks in Advance. Regards, Srinivasan.
Auto assign group ticket to tech in sequential order
Is there a way, when a tickets are assigned to a group (ex. network) the ticket is auto assigned to the next technician in line? For example assuming 3 techs in the group: Ticket 1 assigned to network group - auto assigned to tech 1 Ticket 2 assigned to network group - auto assigned to tech 2 Ticket 3 assigned to network group - auto assigned to tech 3 Ticket 4 assigned to network group - auto assigned to tech 1 Ticket 5 assigned to network group - auto assigned to tech 2 Ticket 6 assigned to network
Increase trial version...
Our trial version for service desk plus is expiring today...we are already in process of purchasing the software and will take another 5 days to make payment... Please let us know how can we make it up and running by then,,,thanks... Regards/Mudasar
How do I set a rule to auto assign a call to a user based on a sender of an email to Help Desk
Have SQL Mail sending nightly emails to our service desk email account so a call can be generated. How can I get the call auto assigned to me in rather than coming in unassigned? I recall something like this was possible in a previous version, but wondering if it is possible now?
Add Available Columns to Admin/Asset Management - Product Screen
It would be useful to be able to view "Type" and "Category" (As are available on the "Asset Management - Product Type" screen - see illustration) when viewing and sorting "Products".
New field in post Event
hello all, i created a new field in my solution with name Test. I have a form that maked a post in url of helpdesk. How i add my new field in url POST? I dont know the name for post! tks
Physical Memory% Question
I'm using your trial sw to monitor 2 AIX ervers and it always shows the physical memory in 99%. I execute svmon -G and I see that 50% of the memory is free. Each server has 11GB and 2 tomcats with 2GB each.
OpManager mtce over midnight
How do you assign mtce past midnight, OpManager insists that 00:30 is wrong it the start period is 23:00 The best you can manage is 23:00 to 23:45, then 00:00 onwards, leaving a gap of 15 mins
Outbound email from business unit displays main reply to email
I have setup the business units, the inbound emails are XXX@123.com and XXX@abc.com the inbound requests are routed to the correct business unit, however when auto replies are generated the reply/from address shows the main email XXX@123.com. So when a contact replies to the request it is routed to the wrong business unit and a new ticket is created in the main business unit. How do I get the reply to field on the different business units to display the correct reply to address? Please help ASAP
Next Page