Sponsored Content
The Lounge What is on Your Mind? Purge of Inactive Users with Zero Posts and Other Anti-spam Measures Post 303023539 by Neo on Wednesday 19th of September 2018 03:39:27 AM
Old 09-19-2018
Haha.

Was going to run this query, but decided not to:

Code:
delete user where posts=0 and post_thanks_thanked_posts < 1 and post_thanks_thanked_times < 1 and lastactivity < 1420070400;

Delete all users who have no posts, never thanked anyone, never received any thanks, and have not been active since 1 Jan 2016.

But that's a big number (67652).

I'll stop and not delete these inactive, thankless, and none contributing 67652 users yet.

Maybe I'll refine the query by country or email address in the future.

Smilie
 

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to logout inactive users????

I would like to automatically logout from the system inactive users depending on their functions. For example there are users that I would like to logout after 15 minutes of inactivity, but there are others that I would like to logout after 30 minutes of inactivity. It's possible to do this??? (6 Replies)
Discussion started by: rrivas
6 Replies

2. UNIX for Dummies Questions & Answers

List all inactive users who has not logged on since last 90 days

Hi, Can I get a script to list out all the users, who has not logged on since last 90 days. Last command in not working due due to /var/adm/wtmpx is more than 2 GB. Thanks in advance. Regards, Roni (10 Replies)
Discussion started by: manasranjanpand
10 Replies

3. Solaris

List all inactive users who has not logged on since last 90 days

I need actuall script which List all inactive users who has not logged on since last 90 days Thanks in advance. Di! (17 Replies)
Discussion started by: haridham
17 Replies

4. Shell Programming and Scripting

Deleting Inactive Solaris users

Hello, I want to do a search for users on my solaris boxes that have been inactive for a defined number of days and then delete them. Any ideas how to determine or calculate the number of days (possibly using the /var/adm/wtmpx file) from the user's last login to the current date of search. ... (0 Replies)
Discussion started by: prince2010
0 Replies
imqusermgr(1M)						  System Administration Commands					    imqusermgr(1M)

NAME
imqusermgr - command utility for managing a Message Queue user repository SYNOPSIS
/usr/bin/imqusermgr subcommand [[option]...] /usr/bin/imqusermgr -h /usr/bin/imqusermgr -v DESCRIPTION
The imqusermgr utility manages a file-based user repository to authenticate and authorize users of a Message Queue message server. imqusermgr provides subcommands for adding, deleting, updating, and listing user entries in the repository. imqusermgr supports four management subcommands. These subcommands, and their corresponding options follow the imqusermgr command on the command line. See USAGE and OPTIONS. The following subcommands are supported: add Add a new user and associated password to the repository. delete Delete a user from the repository. list Display information users in the repository. update Update the password or state of a user in the repository. OPTIONS
The following options are supported: -a active_state Specify if user's state is active or inactive. An inactive user cannot create connections to the Message Queue message server. Valid values for active_state are true or false. Specify true for active or false for inactive. the default is true. Use this option with the update subcommmand. -f Perform action without user confirmation. Use this option with the delete and update subcommmands. -g group Specify the group of the user. Valid values for group are admin, user, and anonymous. Use this option with the add subcommmand. -h Display usage help. Exceute nothing else on the command line. -i brokerName Specify the broker instance user repository to which the command applied. If you do not specify brokerName, the default brokerName is assumed. Use this option with the add, delete, list, and update subcommmands. -p password Specify user password. Use this option with the add and update subcommmands. -s Silent mode. Display no output Use this option with the add, delete, and update subcommands. -u userName Specify user name. userName cannot contain the following characters: asterisk (*), colon (:), NEWLINE, or RETURN. Use this option with the add, delete, update and list subcommands. -v Display version information. Exceute nothing else on the command line. USAGE
The following subcommands and corresponding options are supported: add -u userName -p password [-g group] [-s] [-i brokerName] Add a new user and associated password to the repository, and optionally specify the user's group. delete -u userName [-s] [-f] [-i brokerName] Delete a user from the repository. list [-u user_name] [-i brokerName] Display information about the specified user in the repository. If no user is specified, all users are displayed. update -u userName -p password [-a state] [-s] [-f] [-i brokerName] update -u userName -a state [-p password] [-s] [-f] [-i brokerName] Update the password or state (or both) of a user. ENVIRONMENT VARIABLES
The following environment variables affect the execution of this command: IMQ_JAVAHOME Specify the Java 2 compatible runtime. When this environment variable is not set, it defaults to /usr/j2se. EXIT STATUS
The following exit values are returned: 0 Successful completion. >0 An error occurred. FILES
/etc/imq/passwd Flat-file user repository. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWiqu | +-----------------------------+-----------------------------+ SEE ALSO
imqadmin(1M), imqbrokerd(1M), imqcmd(1M), imqdbmgr(1M), imqkeytool(1M), imqobjmgr(1M), attributes(5) Sun Java System Message Queue Administrator's Guide SunOS 5.11 23 Mar 2004 imqusermgr(1M)
All times are GMT -4. The time now is 07:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy