lclemmons

Thanks!

Now that I think about it.. Isn't a table variable only local to the procedure it's in? If so, this won't work because I wouldn't be able to use a union in my final select statement. Ugh. I hate this kind of programming. Laura

Thanks! I hadn't found the report lab. I posted over there.

Actually, I don't want to exclude multiple connections from the same mac. Administration would prefer counting one patron per day so the same PC connecting in the morning and afternoon of the same day they want counted as one. However, the same PC connecting the NEXT day would count as a second connection. They'd rather…

I'm betting on this. I do have a case statement in there as well as a table variable. I'll see if I can figure out the stored procedure thing. The query isn't actually finished yet. I was just testing an intermediate stage. I'm going to need a union to get the output I want I think. Thanks for the responses. Laura

Dissapointing. I'd contact tech support or add it as a feature request.

Thank you! That was very helpful. I'll redo the alert this afternoon. I also think I'll test it tomorrow before people come in to work by shutting down an unimportant switch and unimportant server rather than relying on their test panel. I've always suspected the test panel isn't doing exactly what it appears to do.

That did the trick. I can't believe I missed it. Thank you very much.

File attached as requested. Thanks for the help.

I am also trying to get the duration for bandwidth utilization events. Specifically, my director wants a report that tells him how many minutes each location spends utilizing more than 80% bandwidth each month, preferably only during open hours but I'll take the entire day if I can get it. Right now, I'd take being able to…

Thank you. Report writer won't allow me to paste in a sql statement but I can use this from sql management studio if need be. At least I can get the numbers manually now until I figure out how to script it. I'll also be able to modify it to give a bit more information based on what I'm seeing in the sql statements in the…

Select the ip address you want to block from scanning then click edit. Change the drop down box labeled scanning to off. You'll have to do this for each IP you want to block from scanning.

Of course I find the answer as soon as I post the question. Turns out report writer automagically assigned field formats, probably based on the column titles matching keywords like year and month. I changed all the fields to no formatting and got the report I expected to get. Sorry to disrupt your day. Carry on. Laura

Also, any suggestions on how to deal with laptops? Our staff have docking stations gving them a hard connection but they forget to turn their wireless off when they dock. This results in laptops showing up with DNS mismatches because the the same name shows up with two IPs (both of which are valid).

Option 150 is a cisco proprietary option for Call Manager isn't it? I seem to recall that from a few years ago when I worked for a company that also did voice installs. If that's what you're trying to configure, is your actual DHCP server on a windows server, linux/unix, or a cisco device? I'm not too sure about linux/unix…

THANK YOU THANK YOU THANK YOU! This makes SO much more sense to me than trying to figure out the calculations on the datetime stamp. My director is ok with this approach as long as he can get his information to a resolution of 5 minutes or so. At that resolution it's going to be one huge events table . One more question...…