Dear community,
I woul like to make a query to output all the users having the same IP address.
The table is somethig like:
I used this query and it works:
The only problem I have, is that in the result I got only the first username:
As you can see user1 and user 4 have the same IP, so I'm expecting somethig like:
How can I output the usernames with the same IP as the example?
hi all
i am new in unix programming i want some help from this forum, i want to know how to get user name of other machine in local network from its ip address or suggest any books for networking programming on unix
sachin (6 Replies)
Greets all,
I'm using Perl trying to insert an IP address from a log file into an INT field in a MYSQL table. So it needs to be converted into an int first. I thought the pack() function could do this for me, but I'm not sure I get the right thing. I also need to be able to extract it correctly... (3 Replies)
hi all,
I have 4 scripts which i would need to run
1. BP.sh
2.DB.sh
3.LK.sh
4.TB.sh
I would like write a script which would ask the user to select a number from 1-4 accordingly and run only that script for him/her
I succeeded till reading the user input but not sure how to run that... (5 Replies)
Hi,
I'm brand new here and looking for a solution:
I'm using mail or mailx. The default reply address is «myshortusername@mylongusername.local» which makes absolutely no sense for anybody receiving my emails.
But how do I change it? There seem to be many solutions but none for Mac OS X.... (0 Replies)
:) Firstly Hi all!!, im NEW!! and on here hoping that someone might be able to offer me some help... i have a server that keeps crashing every few days with the error message:
PANIC KERNAL-MODE ADDRESS FAULT ON USER ADDRESS 0X14
KERNAL PAGE FAULT FROM (CS:EIP)=(100:EF71B5BD)
EAX=EF822000... (10 Replies)
Hello there.
I've got the query like that
SELECT count(tour_id) AS cnt
FROM orders
JOIN tours
ON orders.tour_id=tours.id
GROUP BY tour_id
The result Is
cnt
1
4
2
1
1
Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.... (2 Replies)
Hi there,
I have trouble selecting record that contain one biggest value for a group of other values. I mean, this is my table:
mysql> SELECT * FROM b;
+----+------+-------+
| id | user | value |
+----+------+-------+
| 1 | 1 | 100 |
| 3 | 1 | 150 |
| 5 | 1 | 300 |
| 6... (20 Replies)
i have a table
records
------------
id | user | time | event
91 admin | 12:00 | hi
92 admin | 11:00 | hi
93 admin | 12:00 | bye
94 admin | 13:00 | bye
95 root | 12:00 | hi
96 root | 12:30 | hi
97 root | 12:56 | hi
how could i only select and display only the user and event from... (6 Replies)
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (0 Replies)
hi..
i need to optimize my select query ..
my situation is like this ..
i have 15 lac recors in my table..
the following query takes nine seconds to give the required output..
SELECT max(ah.AUC_AMT),
SUBSTRING_INDEX(GROUP_CONCAT(SUBSTRING_INDEX(ah.AUC_CUS_NAME,'@',1) order by AUC_AMT... (1 Reply)
Discussion started by: senkerth
1 Replies
LEARN ABOUT OSF1
mrinfo
mrinfo(8) System Manager's Manual mrinfo(8)NAME
mrinfo - Displays configuration information from a multicast router
SYNOPSIS
/usr/sbin/mrinfo [-d debug_level] [-r retry_count] [-t timeout_count] multicast_router
OPTIONS
Sets the debug level. When the debug level is greater than 0 (the default), additional debugging messages are printed. Regardless of the
debug level, if an error condition occurs, mrinfo writes an error message and terminates. Nonzero debug levels have the following effects:
Prints packet warnings to stderr. Prints all level 1 messages and notifications of down networks to stderr. Prints all level 2 messages
and notifications of all packet timeouts to stderr. Specifies the number of times to retry a neighbor query. The default is 3 retries.
Specifies the number of seconds to wait for a neighbor to reply to a query. The default timeout is 4 seconds.
DESCRIPTION
The mrinfo command displays the configuration information from the multicast router multicast_router.
The mrinfo command sends the ASK_NEIGHBORS IGMP message to the specified multicast router. If the multicast router responds, the response
includes the version number and a list of addresses for their neighboring multicast routers. If the responding router has a recent multi-
cast version number, mrinfo requests additional information such as metrics, thresholds, and options from the multicast router. Once the
specified multicast router responds, the configuration is displayed to the standard output.
RESTRICTIONS
You must be superuser in order to run mrinfo.
EXAMPLES
The following example shows the output of the mrinfo command where mbone.phony.dom.net is specified as the multicast router: mrinfo
mbone.phony.dom.net 127.148.176.10 (mbone.phony.dom.net) [version 3.3]:
127.148.176.10 -> 0.0.0.0 (?) [1/1/querier]
127.148.176.10 -> 127.0.8.4 (mbone2.phony.dom.net) [1/45/tunnel]
127.148.176.10 -> 105.1.41.9 (momoney.com) [1/32/tunnel/down]
127.148.176.10 -> 143.192.152.119 (mbone.dipu.edu) [1/32/tunnel]
For each neighbor of the queried multicast router, the IP address of the queried router is displayed, followed by the IP address and name
of the neighbor. In square brackets, the metric (cost of connection) and the threshold (multicast ttl) are displayed. If the queried multi-
cast router has a newer version number, the type (tunnel, srcrt) and status (disabled, down) of the connection are displayed.
SEE ALSO
Commands: map-mbone(8), mrouted(8), mtrace(8)
Networking: mbone.info(7)mrinfo(8)