Hey all
I've got 2 questions for u.
let me explain the situation.
We have got several of our customers that can login to the solarwinds website and see a map of their network with their own nodes on it. Each customer has it's own login to the website. We also use this login name in a custom field on the node that we name CustomerName.
We now want to create a report so that the customer can log in to the website and see the events of the last x-days. for this I created an sql query:
use solarwinds
DECLARE @Customerid varchar(30);
SET @Customerid = 'customername';
SELECT
Nodes.NodeID AS NodeID,
Events.EventTime AS Event_Time,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Events.Message AS Message
FROM
Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetObjectID)
where CustomerName = @Customerid
ORDER BY 2 DESC
1) is it possible to use the login name from the website and put it in the @customerid value? This way I would need only 1 report and don't need to create a report for all the existing and new customers.
2) when i run this query in sql sever management studio, it's like speedy gonzales, if I run it as an sql report in the solarwinds reporting tool, it doens't give me any results, it hangs on Querying database.
Any idea's
I'm on holiday for 2 weeks so I'm sorry if I don't reply quickly, but all answers are welcome.
with kind regards
sasuke