The tag has no wiki summary.

learn more… | top users | synonyms

-2
votes
1answer
55 views

How To List All Computers Operating System On A Network In Powershell

I am looking for a script to show all the machines, hostnames, and OS versions on my domain. I have found a few scripts, but none of the scripts that I have found will do both. Here is an example of ...
1
vote
1answer
43 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 ...
0
votes
1answer
56 views

Powershell - query non-standard group members in an OU?

I am looking to create a script which will only show users in an OU who are members of "non-standard" groups. For example, all users in the "Accounting" OU will be members of at least one group with ...
0
votes
1answer
11 views

Query Sring - Variable redirection

I need help on this query string: I am using IIS 8 and I have this URL: http://automotive.ooplinks.com/index.php?route=product/search&filter_tag=westin *I would like to redirect the variable ...
1
vote
1answer
56 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% ...
4
votes
1answer
243 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 ...
-1
votes
2answers
260 views

SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts

Which time out value does SQL server takes while executing the query/ stored procedure? The application time out is set at 20 minutes, the SQL Query/ command timeout is set at 10 minutes, then there ...
1
vote
3answers
91 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
103 views

Ldap query on single subOU for Alfresco

this is what my ldap looks like : red.lan Groups(OU) Computers(SubOU) Printers(SubOU) Users(SubOU) Some(OU) Users(OU) SomeOther(SubOU) So, i'm trying to ...
4
votes
2answers
235 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, ...
-1
votes
1answer
31 views

Apache File Query [closed]

I have an Apache server that has multiple files located on it. Each file is an updated version from the previous file. Eg. release-2013-07-20 is an older file and release-2013-07-25 is the newer file. ...
2
votes
1answer
29 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 ...
0
votes
1answer
49 views

Why does this RewriteRule in httpd not work?

I tried to set this RewriteCond in httpd 2.4.4: ... RewriteCond expr "%{QUERY_STRING} =~ /welcome/" RewriteRule ^(.*)$ %1\.html So, if I visit https://localhost/?welcome , for example, I should see ...
0
votes
0answers
23 views

Is there a way to paginate an API call to ec2 DescribeImages?

How do you paginate API calls in EC2? I made a simple call to DescribeImages on EC2 (without any of the optional query parameters), and it takes about 20 seconds to respond, returning hundreds or ...
0
votes
3answers
115 views

Query DNS for multiple domains at once

I have recently moved servers and want to query all of the accounts domains on the new server to check that they are all resolving to the correct NS. I am currently using ...
1
vote
1answer
500 views

PostgreSQL raw query vs “Function returns TABLE” - insane difference in performance. Why?

I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows: There is a complex query which returns report data, like this: select Column1 as Name1, ...
1
vote
1answer
92 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.
0
votes
3answers
1k views

DNS searching with wildcards?

Anything like nslookup or dig offer the ability to search based on something contained in the name ... like a wildcard search or something? I'm trying to make a little script with a GUI wrapper for ...
1
vote
1answer
2k 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: ...
0
votes
1answer
200 views

Centos Bind remote query issue

I have trouble with remote access to dns server Ip address of server is 199.175.53.128 I run this command from server host cloudauth.me. 199.175.53.128 this command returns Using domain ...
2
votes
1answer
3k 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 ...
0
votes
1answer
98 views

how to see queries to oracle database

the database in question is Oracle 10g Enterprise software the tools available are Toad, SQL Developer, and other built in oracle tools I have an application server within the network, alongside the ...
1
vote
1answer
273 views

Can IP tables allow specific DNS queries based on domain name?

I have iptables blocking all UDP traffic at the moment, however I want to allow only certain DNS queries to get through. Let's use google.com as an example. I am trying to use string matching to ...
-1
votes
3answers
456 views

Redirect MySQL queries to another server [closed]

In order to lower system usage I'm planning to use another server to store my databases. so how can I redirect MySQL queries to another server or make MySQL to store databases on another server?
-1
votes
1answer
511 views

How to speed up a MySQL Import [closed]

I posted a related question on askubuntu.com, but this may be a better place and way to ask it. I'm working on a way to speed up a db import. Currently the import is taking a week, give or take a few ...
2
votes
1answer
637 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 ...
1
vote
0answers
67 views

Query Windows Search Server Express via another web page/server (apache et.al.)

I have Windows Search Server Express; is it possible to query it from another web site, running on Apache? Background: the Apache server runs an intranet site and needs to be able to query the data ...
5
votes
2answers
127 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 ...
-3
votes
1answer
84 views

MS Exchange script to summarize emails by title

We have Microsoft Server 2008 64 bit running Exchange 2007 64 bit. We would like to run a script to summarize all emails sent to 3 different email accounts on this exchange server according to a ...
1
vote
1answer
48 views

SQL Performance - Convert parameter or column type

I was asked this on an interview, and would like some feedback... I have a stored procedure that takes in a varchar parameter IsActive that is either a "YES" or "NO" string. The stored procedure ...
0
votes
3answers
23 views

Apache / PHP Begins to Deny SQL Requests after about 2000

We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 ...
1
vote
2answers
33 views

Is it possible to use workbench to connect to a linux server and send the output to a csv or text file?

I have a user that is using workbench to connect to a Linux MySQL Server and would like to have the query results sent straight to a csv or text file on his computer. I know how to do it if I were ...
0
votes
1answer
513 views

MySQL slow query log logging all queries

We have a MySQL 5.1.52 Percona Server 11.6 instance that suddenly started logging every single query to the slow query log. The long_query_time configuration is set to 1, yet, suddenly we're seeing ...
3
votes
1answer
372 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.
0
votes
0answers
211 views

Remote mysql server slow

I need some help on speeding websites loading. I have two virtual machines created on my ESXi host. Thay are both on public IP addresses and that is how they communicate. On one virtual machines I ...
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 ...
8
votes
3answers
5k 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 ...
0
votes
2answers
720 views

SQL query to Automatically Export to file and FTP?

I am wondering if there is such a way to automatically run SQL queries and export to file (example: csv file) and then FTP to desired location? It seems simple and would need something like this as it ...
1
vote
1answer
348 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
447 views

Mysql server high trafic makes websites really slow or unable to load

Lately we have been having a lot of problems with our mysql server, from websites being really slow or even unable to load them at all. The server is a dedicated server that only runs our mysql ...
0
votes
1answer
370 views

How to create one update query (mysql) on multiple databases

I have several DBS on the same mysql server. The DBS's structure and schema are exactly the same (only data is different) the query on certain db works well like this (written in phpmyadmin) UPDATE ...
0
votes
1answer
121 views

Mysql slow query log not tally with mysqladmin

I have enabled my slow query log. So I saw the query which was taking some time then I did some indexing it improve and my slow query log is not being showing any more queies. But when I run this ...
-1
votes
1answer
68 views

Slow Query in Big Tables by a field has INDEX [closed]

i don't understand the problem in this query, when I make a query with a condition of category_id = 'XX' the query take MINUTES to execute, but the same query without filter by category_id take 0.09 ...
0
votes
2answers
398 views

MS SQL Server Query Timeouts

I've got a server hosted at Rackspace that is a pretty beefy machine (dual hex core, 48 GB of RAM) and our database isn't all that big (100GB or so). SQL Server 2008 R2 Standard 64 bit. Normally, ...
1
vote
2answers
481 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
0answers
167 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 ...
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
5k 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 ...
0
votes
1answer
593 views

how solve Recursive Queries error in intodns web site?

Please see the below link : intoDNS Web Site How can I solve Recursive Queries error! the entire error is below : Recursive Queries I could use the nameservers listed below to performe ...
1
vote
3answers
308 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 | ...