Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
1
vote
2 answers

Create SCCM device collection based on last logged on users who are members of an AD security group

I'm trying to create a device collection in SCCM 2012 which contains only the devices who are used by the users who are members of a certain User AD Security Group. I tried to accomplish this by first making a query for all the users in the group,…
Chobom
  • 33
  • 1
  • 6
1
vote
3 answers

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 indexes, and around 8.7 million records, if I…
Ahmad Hamad
  • 11
  • 1
1
vote
2 answers

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 portion is mysteriously appended to the generated URL…
manchine
  • 51
  • 1
  • 7
1
vote
1 answer

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 query the Uninstall registry key on the target…
HoRuSHigh
  • 11
  • 3
1
vote
1 answer

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 as d inner join DevicePool as dp on…
driz
  • 277
  • 1
  • 12
1
vote
1 answer

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% CPU. and 6.5 %MEM (results obtained by running…
Devontrae Marqualius Walls
  • 23
  • 1
  • 4
1
vote
1 answer

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 make a query that would select all the groups in Users(SubOU), but not…
PaKempf
  • 63
  • 1
  • 10
1
vote
3 answers

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 regular expression), I want to know if Sql Server…
Chris
  • 1,063
  • 4
  • 12
  • 18
1
vote
1 answer

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.
Diosney
  • 305
  • 5
  • 12
1
vote
2 answers

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 on the Linux box, but not from workbench. I know…
Jeff
1
vote
1 answer

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 will query a table that has an Active column with a…
LeanT
  • 11
  • 1
1
vote
1 answer

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 Directory Certificate Services role with mostly…
ToastMan
  • 544
  • 4
  • 18
  • 29
1
vote
3 answers

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 database. i have been running some test using a…
Holapress
  • 11
  • 1
  • 2
1
vote
1 answer

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 command mysqladmin -u root -p status Enter…
user111196
  • 1,257
  • 2
  • 13
  • 14
1
vote
1 answer

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 (everything described with DDL (tables, columns,…
Ben
  • 11
  • 1
1 2 3
…
13 14