I had a problem, I had to work in 2 different networks but with only one default gateway i was not able to talk to both networks. So if you open up a command prmp(cmd) but open it by right clicking and then clicking open as admin. Once your at the command prompt type this but change my network numbers to the ones you want to get to. “route add 10.128.0.0 mask 255.255.0.0 10.100.1.91″
and boom without haveing to configure anything on my default gateway now i can access both networks from my one machine. Thanks and let me know if you have anty questions.

Okay I used this SQL Script to join two tables but a certain amount of rows has to be joined with another table, here is how i did it with a join and union operation

UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1
WHERE col_ID in (select col_id
from tbl_fruit
where col_id=2)

In Solaris the command line has to be used all the time. One task that you will run into either through Solaris, Linux, OSX, or even the iphone OS is the moving of files. here is the command and you can use it at will.

Move all files in directory to test directory: mv * /test

Move one file only: mv onefilename /test

Let me know what you think and if you have any tips yourself!

Thanks

Scott @ http://scottalvarino.com

Thanks

Scott @  http://scottalvarino.com

select –*,
Unit_Name, Caller, Callee, Group_name as “GroupNombre”, –Unique_Id, –Group_name as “GroupNombre”,
c.Call_Type,
e.Description,
– convert(char(15),Event_At,120) “DATE& TIME”,
convert(varchar,Event_At,111) “DATE”
– convert(char(13),Event_At,120) “DATE& TIME”, Caller,
–$$$$$$*********CALL TYPE AREA**********************************************
– SUM(CASE call_type WHEN 0 THEN 1 ELSE 0 END) “GROUP CALLS”, — THIS IS GROUP CALLS
– SUM(CASE call_type WHEN 1 THEN 1 ELSE 0 END) “I CALLS”,
– SUM(CASE call_type WHEN 2 THEN 1 ELSE 0 END) “EMERGENCYS”,
– SUM(CASE call_type WHEN 3 THEN 1 ELSE 0 END) “SYSTEM ALL”,
– SUM(CASE call_type WHEN 4 THEN 1 ELSE 0 END) “MORSE CODE”,
– SUM(CASE call_type WHEN 5 THEN 1 ELSE 0 END) “TEST CALLS”,
– SUM(CASE call_type WHEN 6 THEN 1 ELSE 0 END) “PAGING CALLS”,
– SUM(CASE call_type WHEN 7 THEN 1 ELSE 0 END) “SCRAMBLE DATA”,
– SUM(CASE call_type WHEN 8 THEN 1 ELSE 0 END) “LOGINS”, — THIS IS GROUP SETS
– SUM(CASE call_type WHEN 9 THEN 1 ELSE 0 END) “SYSTEM LOGIN”,
– SUM(CASE call_type WHEN 10 THEN 1 ELSE 0 END) “START EMERG”,
– SUM(CASE call_type WHEN 11 THEN 1 ELSE 0 END) “CANCEL EMERG”,
–$$$$$$*********CALL STATE AREA*********************************************
– SUM(CASE call_state WHEN 0 THEN 1 ELSE 0 END) “All CALLS”,
– SUM(CASE call_state WHEN 1 THEN 1 ELSE 0 END) “DROPPED CALLS”,
– SUM(CASE call_state WHEN 2 THEN 1 ELSE 0 END) “KEYED”,
– SUM(CASE call_state WHEN 3 THEN 1 ELSE 0 END) “UnKeyed”,
– SUM(CASE call_state WHEN 4 THEN 1 ELSE 0 END) “DIGITS”,
– SUM(CASE call_state WHEN 5 THEN 1 ELSE 0 END) “OVER DIGITS”,
– SUM(CASE call_state WHEN 6 THEN 1 ELSE 0 END) “QUEUE”,
– SUM(CASE call_state WHEN 7 THEN 1 ELSE 0 END) “BUSY”,
—- SUM(CASE call_state WHEN 8 THEN 1 ELSE 0 END) “DENY”,
– SUM(CASE call_state WHEN 9 THEN 1 ELSE 0 END) “Cnv to CALLEE”,
– SUM(CASE call_state WHEN 10 THEN 1 ELSE 0 END) “DEQUEUE”,
– Count(Caller) As CountS
From Log_activity_localtime c
Left Outer Join Unit ON c.caller = Unit.Unique_Id
LEFT OUTER JOIN Groups ON c.callee = groups.Unique_Id
Inner Join dbo.Enum_Call_Type e On c.Call_type = e.Call_Type

– From Log_activity_localtime c
– LEFT OUTER JOIN Groups ON c.callee = groups.Unique_Id

Where
– convert(char(15),Event_At,111) between ‘2010/05/11′ and ‘2010/05/12′
– event_at between ‘2010-05-11 00:00:00.000′ and ‘2010-05-13 00:00:00.000′
convert(varchar,Event_At,111) between ‘2010/05/11′ and ‘2010/05/14′
and (caller = 3394
or callee = 3394)

–GROUP BY
– convert(varchar,Event_At,111) — DAY
– convert(char(13),Event_At,120)– HOUR
– convert(char(15),Event_At,120)– HOUR/MIN
– , Caller

This is for A Unix Solaris Box, I never had access to its Sybase before and needed to find out how to remotely connect with it to use different tools to write reports and administer the system. this is much like in the Microsoft SQL DB world where you have SQL Query Analyser and Enterprise Manager For the Windows Side of things.

Will have up soon, please let me know if this of any interest?

Scott

Click HERE!!

I also use Firefox whenever a site is not compatible with Opera http://www.opera.com. Let me know what you think with a comment. Also let me know if you want me to test each browser with a couple test to see which one is the most secure. Let me know

SA

Thanks

SA

Is the latest project I have been working on. These are just a couple of the things that can be done with my favorite blogging software Wordpress!. Anyways I been super busy at work and have been trying to finish all my tasks, But I have alot of video that just needs to be uploaded and I am still working on My Cisco Command Cheat Sheet for all you Network Junkies.

Bye For now