The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
32 views

I am confused about the Authoritative DNS Server actual definition

I search for this a lot and the answer is the same everywhere: Authoritative servers give either the answer or "NO", the host does not exist. Non-Authoritative servers use either cache or a ...
1
vote
2answers
32 views

Any solution for MySQL Servers to avoid rendering them unresponsive when running big queries?

I do run several mysql servers for several clients, there is a common problem I used to see. When I run some big query against big databases, for example: I have a MyISAM table with several fulltext ...
0
votes
2answers
2k views

apache - query string rewrite rule appends condition to URL

In trying to rewrite site-search.html?searchword=search%20term as advanced-search#q=search%20term I always end up with advanced-search#q=%3Fsearchword%3search%20term The %3Fsearchword%3 ...
1
vote
1answer
94 views

AWS CLI Command Line: How to use “--query” to output multiple source lines

I am using aws-cli version 1.7.8 to get the --query output to create one record that is derived from multiple lines. In this case I am trying to get specific information from describe-instances. In ...
0
votes
2answers
45 views

ldap query with nested group

I try to build a ldap query to MS Active Directory. I found that there is a LDAP_MATCHING_RULE_IN_CHAIN type to do so. Which results in the follow syntax: ...
-1
votes
0answers
13 views

mysql slow log filling up without queries

I have slow query logging turned on but have noticed it just fills up with this repeated. It's in there close to 5000 times since yesterday when I reset the log file. There are no slow queries on the ...
-1
votes
2answers
49 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
11
votes
10answers
50k 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 ...
-1
votes
1answer
553 views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
14
votes
4answers
4k 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 ...
0
votes
3answers
3k views

The database at work has Unidata format, how do I access it?

I know just enough about database to get by - it's not normally within the scope of my job, but I think it's good for everyone to know a little bit. I'm trying to access some of the data in our DB ...
-1
votes
2answers
7k 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 ...
0
votes
1answer
28 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
2answers
33 views

bind cache not used?

i installed a classic bind9 dns server inside a local network, working as a forwarding dns server, there is my config file (i just added my ISP DNS servers as forwarders): options { directory ...
-1
votes
2answers
2k 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 take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
0
votes
1answer
71 views

How to use variables in inner queries?

I am trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') ...
0
votes
1answer
72 views

dns hierarchy not returning ip address

(DNS1 ,WWW1, Gateway1) (sub-internal network) (DNS0,WWW0,Gateway0) (internal network) DNS1: 192.168.250.3/24 WWW1: 192.168.250.4/24 Gateway1: 192.168.250.1 /24 (internal) :: 192.168.0.150 ...
0
votes
0answers
29 views

Cannot query UDP services

I run a couple UDP services, one including Teamspeak 3. Unfortunately, I am unable to query either of these UDP services (I cannot connect to the Teamspeak 3 server) besides the TCP based stuff, ...
-1
votes
1answer
80 views

Find Computers Recently Joined to Active Directory

How can I find Computers recently joined to Active Directory? Edit: I've searched google for the title phrase, and have also searched here, but can find nothing specifically about filtering on when ...
0
votes
0answers
144 views

LDAP query to obtain distinguished name of a list of users

Hi im working on a migration process on which we are migrating users from one server to another domain controller. Right now I have a list of users I migrated, but I also got another of them I didnt. ...
0
votes
2answers
359 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 ...
0
votes
1answer
40 views

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
1
vote
1answer
231 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
votes
2answers
102 views

repeated mysql queries change execution time

I noticed that when I execute a query more than one time consecutively on my mysql machine, the execution time drops and changes significantly (40/50%) after the first execution, and that WITHOUT ...
3
votes
1answer
132 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 ...
0
votes
0answers
47 views

WMI remote query where TimeGenerated > n seconds ago

I'm querying Windows security logs remotely using WMI for a monitoring application and would ideally like to perform the following query: Select * from Win32_NTLogEvent Where Logfile='Security' AND ...
-2
votes
1answer
53 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
0
votes
1answer
41 views

Anyone knows what 173lo.com is - top entry on my BIND DNS server

Administer a DNS server running BIND DNS. We use dnstop to monitor queries. I have 173lo.com as top query with highest count and I'm wondering what the domain is, I can't find really useful ...
0
votes
1answer
671 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 ...
2
votes
1answer
1k 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: ...
1
vote
1answer
571 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 ...
12
votes
3answers
6k 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 ...
1
vote
1answer
52 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
215 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
118 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 ...
1
vote
1answer
589 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 ...
4
votes
1answer
866 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 ...
17
votes
18answers
23k 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, ...
0
votes
2answers
980 views

SQL Server query hangs indefinitely - restoring database only solution

Occasionally we encounter a query that hangs indefinitely on our SQL Server. This query is being called from a separate ColdFusion web server. If I run profiler while it is hung I just see locks ...
1
vote
1answer
1k 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% ...
2
votes
1answer
121 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 ...
1
vote
0answers
87 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 ...
1
vote
3answers
174 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
278 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
445 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
33 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
10k 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
91 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
3answers
679 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
2k 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, ...