The tag has no wiki summary.

learn more… | top users | synonyms

17
votes
18answers
20k views

Are there any good and lightweight LDAP querying tools? [closed]

As developers we sometimes need querying LDAP. Do you know useful tools for this task? edit: I don't mean in code, I mean utility/tool (command-line or gui, mostly gui) for just to look/confirm data, ...
13
votes
2answers
2k views

Why multiple PTR records in DNS is not recommended?

I often read that using multiple PTR records in a DNS configuration is not recommended. However, the reasons are often vague, or not so obvious, naming: "it can cause problems", "can trigger ...
12
votes
3answers
4k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
10
votes
9answers
45k views

Command line active directory query email address for username

On Windows XP in an Active directory environment - what is the easiest way for me to query a user's email address from AD given their username on the command line. (Assuming I know where it is kept ...
9
votes
3answers
8k views

How to automatically kill slow MySQL queries after N seconds?

I am looking for a well tested bash script (or alternative solution) to do so, in order to avoid max_connection to be exhausted. I know that it is fighting the symptoms, but really need such script as ...
5
votes
2answers
142 views

Effects of internet connection speeds on server queries

Can my internet connection significantly effect queries run on phpmyadmin? I am currently 18 down and 30 up. I switched internet connections today and noticed a deep drop in query performance. The ...
5
votes
2answers
1k views

best practice for fixing mysql slow query log error 13

CentOS 5.5 MySQL 5.5 installed via a yum repository [ERROR] Could not use /var/log/mysqld.slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. ...
4
votes
3answers
4k views

Importing a large SQL script into SQL Server?

I'm trying to move a database from our production server to our test server. I've used Microsoft's Database Publishing Wizard to create a script containing the schema and data for the production ...
4
votes
2answers
401 views

What is the most efficient way to add a lot of data to a mysql database?

I have a batch of data that needs to be added to a mysql database every day consisting of about 100K queries. START TRANSACTION; INSERT IGNORE INTO info (Created, Modified, MType, Pform, Name, ...
4
votes
1answer
668 views

SCCM query for cluster (virtual) name

I'm trying to determine if the cluster name is stored in SCCM audit data. I see the host name in [v_R_System], and I'm able to identify cluster nodes here. What I need is the virtual name for the ...
4
votes
4answers
8k views

Why are my MongoDB queries really, really slow?

I've inherited a large MongoDB server at work, and have been tasked with figuring out why queries run against it are so slow. The DB contains tons and tons of records (on the order of 10^9) and takes ...
3
votes
1answer
512 views

How to make BIND behave differently depending on query source?

How would one make BIND behave differently depending on the source IP address? For example, I want to use different forwarding DNS servers for different people on my network.
3
votes
1answer
223 views

Active Directory lookups from bound Mac without user credentials

One of my Mac boot scripts needs to grab a property from AD that is not one of the ones I can see with the built in tool called dscl, which is pretty much limited to Users, Groups, and Computer ...
3
votes
1answer
153 views

Should I be suspicious of this querystring?

I noticed in my application event log some errors: Exception message: A potentially dangerous Request.QueryString value was detected from the client (term="DTİNST32") Request URL: ...
3
votes
1answer
100 views

Expensive LDAP queries from Workstations

Troubleshooting high LSASS process on a DC found expensive queries originating from a few workstations. Each query is as follows: Visited Entries: 1Million+ Returned Entries: <50 (most of the ...
2
votes
1answer
639 views

Search AD for empty sAMAccountName & userPrincipalName

I'm in the process of implementing a User privilege management solution and it needs to audit all users within our AD. It's currently falling over due to an account which has two blank attributes: ...
2
votes
1answer
8k views

bind would not work unless allow-query is “any”

I have this in /etc/named.conf, I commented the default values and set my own under it. My domain would not load in browser unless I set allow-query to "any", is this OK, what should I edit? If is ...
2
votes
1answer
14k views

SCCM 2007 Query for installed software versions

How can I write a query to find machines which installed office 2003 with Sp3 in SCCM 2007? Thanks,
2
votes
2answers
590 views

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a ...
2
votes
1answer
109 views

pl/sql Oracle syntax

I have a query in pl/sql that i need to migrate to ms sql. select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+) Could anyone tell me what the (+) after ...
2
votes
2answers
2k views

Zabbix - Populate Item with SQL Server Query

I'm trying to track a process that locks up regularly. It's a funky program that we have no control over. I'm trying to find a good way to track when the program stops responding. I have a query ...
2
votes
1answer
91 views

SCCM 2007 query to select users belonging to listed AD groups

Can somebody advice me on WQL query to select all users from specified AD groups? I tried to do this through query builder but without success. I'm going to use these selecter user to further select ...
2
votes
1answer
7k views

SCCM how to check installed software versions?

How can I write a query to find machines which installed office 2003 and office 2010 in SCCM version 4.00.6487.2000? I don't have the collection for the PC anymore. It was deleted when we thought ...
2
votes
1answer
1k views

how do I list Distribution Group (List) and their members inside of an OU using AD or exchange 2010

our entire domain has thousands of distribution groups, while i can use the script referenced here: How to get a list of all Distribution Lists and their Members in Exchange 2007? to pull all ...
2
votes
3answers
2k views

Retrieve list of users/groups that have access to a network folder and its subfolders?

One of our users is requesting a list of the users and groups that have access to two folders on the network, as well as all of the subfolders of both of these folders. There are hundreds, if not ...
2
votes
1answer
193 views

Simple SQL Server 2005 Replication - “D-1” server used for heavy queries/reports

We have two SQL 2005 machines. One is used for production data, and the other is used for running queries/reports. Every night, the production machine dumps (backups) it's database to disk, and the ...
2
votes
1answer
135 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
2
votes
2answers
135 views

MySQL query times for tuning are different every time

I am tuning SQL query time for my slow query but every time I get different times so I can't evaluate my optimize solution. For example, I run query select * from abc where abc.status in (x,y,z) and ...
2
votes
1answer
163 views

SQL server Intergration services 2008 sub queries

I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package. So When I execute the package, I want to be able to execute the sub query after everyline ...
1
vote
3answers
200 views

Can you make MS Sql Server reject all queries matching a certain pattern?

I would like to know if you can make Sql Server look at incoming query strings and reject ones that match a certain pattern. In other words, for a certain class of queries (perhaps identified by a ...
1
vote
3answers
689 views

Perfectly reproducable select statement default ordering issue

I've recently been chasing an issue with a client's db... solution found, but impossible to recreate. Essentially, we're doing a Select * from mytable where ArbitraryColumn = 75 Where MyTable has ...
1
vote
3answers
474 views

Need to fetch result of only one column from the MySQL status variables

I wanted to fetch only the value from status variables. Suppose the query is show status where Variable_name='Aborted_clients' It returns +-----------------+-------+ | Variable_name | Value | ...
1
vote
2answers
1k views

Event logs on multiple server

I am looking for tools that will allow me to aggregate and query event logs from multiple servers. In my case, this is a webfarm and I need to be able to query the event logs for all of them in one ...
1
vote
1answer
124 views

Bind9 how stop to answer specific queries?

How I can make Bind9 to stop answering specific types of queries, let say NULL, WKS or TXT? Thanks in advance.
1
vote
4answers
428 views

why this statement in oracle perform much slower then ms sql

I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow: populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table ...
1
vote
3answers
139 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
1
vote
1answer
537 views

Measure query execution time in bash

I need to measure a query total execution time from inside a bash script. Somebody told me to submit something like: mysql --user="someuser" --password="pw" -D "dbname" -e 'your-sql-command;' Is ...
1
vote
2answers
434 views

Cancel query in MySql

I have a query running for some hours, if I cancel this query what is going to happen to the database? The query is an ALTER TABLE that adds a new column. UPDATE: I executed the script this way ...
1
vote
1answer
554 views

Active directory - query groups by email address

How do I query my workplace's directory to get a list of all the groups with an associated email address that terminates in "fr"? I can use either the AD snap-in or the commandline tools, but no third ...
1
vote
1answer
451 views

Querying SCCM Server to get ADD/Remove Programs list of a specific computer

First of all, i'm sorry for my english. I'm new in vbs scripting and wmi queries and I need your help. My goal is to get the Add/Remove Programs list of a specific computer. I saw many scripts which ...
1
vote
1answer
35 views

OpenLDAP and range attributes

I am trying to query the "member" attribute of a groupOfNames object, and in AD, I can be sure to retrieve all of them, should they exceed the maximum of 1000 entries, by using ranged attribute ...
1
vote
1answer
160 views

Nested/Joined SQL Query to Extract Phone Data From Cisco UCM Database

I need to query numbers of phones per site for Analog, and IP phones separately. I can do it with these two queries. IP Phones: select count(d.name) as IP_Phones, dp.name as DevicePool from Device ...
1
vote
1answer
991 views

MySQL Queries taking too long to execute

I have a database table, with 300,000 rows and 113.7 MB in size. I have my database running on Ubuntu 13.10 with 8 Cores and 8GB of RAM. As things are now, the MySQL server uses up an average of 750% ...
1
vote
1answer
5k views

Event Log > Filter Current Log > XML > where EventData contains text

I'm trying to search through the windows event log for anything where the event data contains the string TCP Provider, error: 0 as part of a longer error message. To do this I created the code below: ...
1
vote
1answer
2k views

Using SSL to Encrypt LDAP Queries - Windows 2008 R2

I'm trying to secure our domain so when LDAP queries are made from another computer they are encrypted with SSL. I followed this guide even thought I am using Windows 2008 R2. I added the Active ...
1
vote
2answers
1k views

Estimating MySQL Query Runtime

I ran a MySQL query from command line using the following: nohup mysql --user=root --password=XXXXXXXXX database < report.sql > results.tab This query is extensive (5000 lines) and running a ...
1
vote
1answer
219 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
1
vote
1answer
309 views

Periodically run query to transfer data between two SQL Servers

I have two MS SQL Servers, let's call them Source and Destination. I need to bring some data from a database table in Source by making a simple query (a Select and a Sum) and bring the result to a ...
1
vote
2answers
257 views

Mysql crashes by some strange queries

I have some strange log entries in my debug where I see that the mysql crashes: Apr 13 08:51:16 cronjob1 mysqld[22953]: Attempting backtrace. You can use the following information to find out Apr 13 ...
1
vote
1answer
264 views

mysql slow query log

I am trying to write a script to parse the MySQL slow query log. I have seen 1 or 2 parser. does anyone know how to extract the information from that log? I mean does anyone know the structure of the ...