SQL Help...command line

bloodline76 · 3 Nov 2010 at 17:09

I am in need of some help running a report.

I need to know of an SQL command that enables me to view Devices that have not responded for a period of 72 hours over a period of 3 months.

So over a three month period I need to know if X stopped for more than 72 hours.

Thanks

shorttricky · 3 Nov 2010 at 17:25

I'd like to know this as well, I have the same problem

coopersim · 3 Nov 2010 at 17:34

Wow! I have the exact same problem! Weird.....

rpstewart · 3 Nov 2010 at 17:39

bloodline76 said:
I am in need of some help running a report.

I need to know of an SQL command that enables me to view Devices that have not responded for a period of 72 hours over a period of 3 months.

So over a three month period I need to know if X stopped for more than 72 hours.

Thanks

You do realise that it's impossible for anyone who doesn't know your data model (ie all of us on here) to answer that?

bloodline76 · 3 Nov 2010 at 17:46

rpstewart said:
You do realise that it's impossible for anyone who doesn't know your data model (ie all of us on here) to answer that?

No I didn't know that or I wouldnt have posted. Can you advise what sort of information you would need to advise?

I am using Envision.

rpstewart · 3 Nov 2010 at 17:56

bloodline76 said:
Can you advise what sort of information you would need to advise?

The names of the tables involved and their columns plus how they interconnect.

By Envision do you mean RSA enVision?

bloodline76 · 3 Nov 2010 at 18:05

rpstewart said:
The names of the tables involved and their columns plus how they interconnect.

By Envision do you mean RSA enVision?

Yes RSA Envision.

How adaptable is that for searching. Can you search for text within a column?

Say I have a line of data:

This is my data.

Can I look for just lines that have "my data"

rpstewart · 3 Nov 2010 at 18:13

I've not got any direct experience of the product but I'd be surprised if it didn't have the capability to do what you want. According to the website there's a reporting engine attached to enVision, does that not do what you want without having to resort to SQL?

bloodline76 · 3 Nov 2010 at 18:17

rpstewart said:
I've not got any direct experience of the product but I'd be surprised if it didn't have the capability to do what you want. According to the website there's a reporting engine attached to enVision, does that not do what you want without having to resort to SQL?

No it is ok but when you need to gather specific information you have to use SQL.

rpstewart · 4 Nov 2010 at 09:08

Have you written SQL against this system before? It strikes me that enVision is not the sort of product that you'd put into a small organisation, do you have a team who supports enVision that could help?

bloodline76 · 4 Nov 2010 at 13:02

rpstewart said:
Have you written SQL against this system before? It strikes me that enVision is not the sort of product that you'd put into a small organisation, do you have a team who supports enVision that could help?

We aren't a small orgainisation. We have engineers but they aren't always willing to help out.