Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-3
votes
0answers
23 views

issues with subquery sql [migrated]

Hi im getting this error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. this is my current SQL query: DECLARE @UgpEntry VARCHAR(50) SELECT @...
0
votes
1answer
63 views

Using SNMP to monitor windows RDP logons?

It is possible to monitor WIN RDP logons (user,login duration) using SNMP specific OID ?
0
votes
1answer
40 views

Rule - Search for my name in outlook messages but ignoring the text inserted in replies

I get a lot of junk emails that require no action from me so I wanted to filter out those that have my name in the body/subject and put them into a special folder. I realized after creating the rule ...
0
votes
1answer
38 views

Strapi + Postgres: Cannot SELECT from table - syntax error

I am using strapi and postgres. I created two collections in strapi called "solutions" and "references". When I run \dt I get the following output: ...more tables public | ...
1
vote
1answer
159 views

Optimizing MariaDB Performance

I need a different set of eyes checking my MariaDB settings. During peak load times, the CPU can hit upwards of 600% or more, and slows down Wordpress application. I have used MySQLTuner to tweak a ...
0
votes
0answers
99 views

PostgreSQL - pg_monitor role

I have problem - probably with postgres permissions. I created a user and granted role to him: CREATE USER test PASSWORD 'abc'; GRANT pg_monitor TO test; Next I want to login as test user and run ...
0
votes
0answers
117 views

Azure Resource Graph Explorer to query “microsoft.recoveryservices/vaults”

I need to use "Azure Resource Graph Explorer" to get the following information from "BACKUP MANAGEMENT TYPE" SQL in Azure VM Azure Virtual Machine Azure Backup Server Azure ...
0
votes
1answer
242 views

Azure : How to process Azure Log events from Event hub and filter based on criteria

How to process Azure Log events from Event hub and filter based on criteria. We are trying to filter specific critical or security related Diagnostic and Activity logs before feeding into our Onprem ...
0
votes
1answer
594 views

AD query - get bitlocker active computers

I have query in Active Directory which should return all computers with bitlocker not active based on this script: https://community.spiceworks.com/topic/1083065-bitlocker-status-on-all-computers ...
0
votes
1answer
20 views

AD Query for non expiring password but filter only active users

I need to do query which filters users with non expiring password setup. I have something like this: (&(objectCategory=person)(objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=65536))...
1
vote
1answer
182 views

Nginx, rewrite get query

I would like to rewrite an url from /shop/?category=kitset-kitchens to shop/category/kitset-kitchens What I tried: rewrite ^/shop.*$ /shop/category/$arg_category permanent; goes to: shop/category/...
1
vote
1answer
85 views

Will a domain controller in the domain that a group is defined contain all member information?

Let's say I have a forest setup with many domains. If I were to pick an arbitrary security group from any of the domains, what is the best way to find ALL user members of that group, including user ...
2
votes
2answers
157 views

Suggested indexes

I am new to indexing in general and have just started learning about query plans etc. I am working on this one specific query that keeps advising me to create the following index: CREATE NONCLUSTERED ...
-1
votes
1answer
1k views

DNS Fails to simple query test

I seem to have a real odd problem that seems to escape me. I have two servers - both of which are ad controllers. My Problem Child is Windows 2008 R2, My other is a Windows 2012R2 that runs no problem....
0
votes
2answers
625 views

MySQL query is very slow over internet

I'm having an issue with a very slow query in an C# WPF application. The application connects to a MySQL-server. As long as the application is used on my LAN, everything is going fast. When i use the ...
0
votes
2answers
322 views

Nginx rewrite query url, redirect and serve content

Apache user here so not very familiar with nginx :) Eg url like this testpage.no/products?test_category=434 How to redirect this url and its content to this url: testpage.no/testcategory is ...
0
votes
2answers
447 views

Exchange 2016 New-Mailboxsearch KQL Query Help - Is this possible? (X or Y) not (Z unless also X)

Thanks in advance for reading & any help you can provide!   I'm trying to do a mailbox search against several mailboxes. I need to find all messages that mention some words AND don't mention ...
2
votes
1answer
2k views

filtering event logs with specific TIME range of ANY day

How can I query windows server events between two times of any day? I have tried with PowerShell... Get-EventLog -Logname xxxx -After 04:00:00 -Before 04:00:30 ...but just returns today's events
1
vote
1answer
2k views

Suspicious DNS query leads to “Intrusion protection alert” on Sophos UTM

A customer Sophos-UTM reports Intrusion protection alert warnings INDICATOR-COMPROMISE suspicious .null dns query: 2019:01:15-11:54:13 utm-ba snort[31619]: id="2101" severity="warn" sys="SecureNet" ...
2
votes
3answers
539 views

Block any query in BIND

I've been trying to block ANY queries in my BIND server with no success. I followed this post Block ANY request in Bind which says that I can use minimal-responses but it doesn't work. None of the ...
0
votes
1answer
914 views

SCCM WQL Query Structure BIOS release date

So with this whole Meltdown and Spectre causing a huge fuss world wide. I have discovered a solution to mass deploy BIOS updates. The one thing is when checking compliance I am unable to locate ...
0
votes
1answer
36 views

Slow SQL Queries over local net

Slow Queries for SQL over 1Gb link between servers using just SSMS Server Configs: Main SQL Node: 32GB Ram 16 cores Sage Evolution Server: 16 cores 16GB ram The config of the servers is that they ...
1
vote
1answer
225 views

Does a DNS server intercept and respond to DNS requests even if it is not the intended DNS server of the requesting machine?

"A" wants to resolve google.com using DNS Server 1 or 2 (as set in IPv4 settings on the NIC). But DNS Server 3 is between "A" and either DNS Server. Will server 3 attempt to respond to the DNS query? ...
0
votes
0answers
82 views

How to make daily database backups readily queryable

We have a production database that generates daily database backups that are uploaded to S3 in form of compressed .sql.bz2 files. We basically have a S3 bucket that has a large number of such backups, ...
2
votes
1answer
5k views

Update InfluxDB measurement names

Is there a way to update existing measurement names in an InfluxDB? When my system was originally set up we used measurement names like "CheckCPU" or "CheckLOAD" and have changed to all lower case ...
2
votes
1answer
259 views

SCCM query based on Device Enrolment Profile

We are pre-configuring our mobile device fleet through Apple DEP into our hybrid InTune / SCCM instance. We have a few different enrolment profiles based on what the device is used for. With this, we ...
2
votes
3answers
320 views

dns: difference between ANY and A query for changed DNS record?

I have recently changed the IP address for a particular domain, call it example.com. I know that it takes time for the DNS change to propagate, and it's still early enough that the propagation is not ...
0
votes
1answer
2k views

ldap query active directory: all users with their assigned groups or groups with their members

I'm trying to make a ldap query which I can run in active directory tool, so I can have an overview of all users with their groups. What do I need to add to this script to see the groups of these ...
-2
votes
1answer
5k views

How do I run specific queries in SCCM using Powershell

Could you advise how could I run query ID using command prompt? For example, I do not want to go to Monitoring-Queries-expand tree and search for the specific querry. I Just want to have script file, ...
0
votes
1answer
495 views

“show processlist;” output - percent sign

In the output above, what does the % (percentage sign) mean ? mysql> show processlist; +------+--------+----------------------+----------+---------+------+--------------+---------------------------...
0
votes
1answer
1k views

MySQL query is NOT executed from bash, but works from MySQL client

Using UBUNTU 16. MySQL query fails from bash, but works from MySQL client: query=$(cat << EOF CREATE DATABASE \`${mysql_local_database}\` /*!40100 COLLATE \'utf8_hungarian_ci\' */; use \`${...
0
votes
1answer
977 views

Large database table queries return empty set

I'm trying to understand a weird problem with a MySQL database on one of my websites. When I loaded a big set of data from a CSV file (2,200,000 records with a single column, using LOAD DATA) into a ...
4
votes
1answer
22k views

openldap sizelimit. Can't receive more than 500 entries

I can't receive more than 500 entries, when I query my openldap-server. Although I made the following changes: slapd.conf # This is the main slapd configuration file. See slapd.conf(5) for more ...
1
vote
0answers
376 views

Pgpool-II would not invalidate query cache for user schemas

I've configured pgpool2 (v3.4.3) with postgresql (v9.5) to cache queries like this: memory_cache_enabled = on memqcache_method = 'shmem' memqcache_total_size = 67108864 memqcache_max_num_cache = ...
-2
votes
1answer
52 views

Filtering query on Nginx [closed]

Can I store a specific query in access_log file by filtering with an expression? For example I want to deny storing queries related to www.mydomaine.com and then reject it ? Best regards, Nizar.
1
vote
1answer
16k views

Obtain a list of computers from SCCM on which a specific software is installed?

I have tried the below procedure to obtain a list of desktops that have software X, version 2.2 installed on them: Device Collections => Create Device Collection => named it "Computers with X ...
0
votes
1answer
1k views

which table should I query for date & time in zabbix?

i need to query date and time in zabbix server. which table exactly stores these 2 parameters? Actually there is a table named history and there are two fields in that table named "clock" and "ns", ...
0
votes
1answer
685 views

Quering history of network interface in zabbix server return empty set?

I've installed Zabbix on Ubuntu. Although I can see a "graph" and related "latest data" for all network interfaces in Zabbix front-end, there is no data for them when I directly query MySQL database!...
7
votes
1answer
117k views

How to use WMIC to connect to remote machine and output OS information to a file?

I want to know how to use WMIC to connect to remote host and output their PC's OS information(Installed programs list) to a file. I tried wmic /node: <IP address> OS get vendor, name > c:\...
1
vote
3answers
2k views

MySql query returns null on ocassions

I'm not sure what exactly is causing this but on occasions a mysql query that I know has to return results will sometimes return null as a result. I've seen this happen twice before but as I couldn't ...
0
votes
1answer
804 views

MSSQL query not working, even if there is data

Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work: SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
4
votes
1answer
1k views

SQL Azure insert query ten times slower on V12 than V11?

I noticed performance degradation about two weeks ago impacting one of our applications with an SQL Azure backend. It's running on V12 on tier S1 90% of the time, sometimes scaling to S2, S3 or P1. ...
2
votes
0answers
224 views

WMI Query - First and Fourth IP octet

Is anyone aware of any WMI queries that could be used within group policy which only lists all IP address, which end in .200 and I have multiple sites, multiple networks, I only need to list the ...
0
votes
1answer
578 views

Finding list of fonts for each PC

I am trying to find the best way to find a list of clearview fonts on each PC on our domain. Questions: 1.) Should I use SCCM & how? I've create a Query but I am getting nothing right now. I was ...
2
votes
0answers
271 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
2
votes
1answer
11k views

SCCM - Query Powershell Version

I am trying to create create a query in SCCM to show how many computers are installed with the different Powershell-versions. I suspect we have a mix of v2,v3 and v4, but I need to know how many and ...
2
votes
3answers
586 views

How to filter a LDAP query for users which are authenticated? [closed]

I want to check if a user is authenticated right now for my Windows domain. For that I want to use an LDAP query. I learned that there is a group "Authenticated Users" (S-1-5-11) which might do the ...
0
votes
0answers
45 views

MySQL execute every query on a second server

I have a Web-application on a Linux Debian 8 Server saving in MySQL. I need a backup which is always the latest version(not even a minute behind) so the only way i could think off to archive this is ...
1
vote
2answers
8k views

WMI query to check for IP default gateway for OSD

I'm trying to add a condition for a command line, which should only be run if the condition is met. I'm doing this by using a WMI Query; Select * From Win32_NetworkAdapterConfiguration Where ...
7
votes
1answer
652 views

BIND - increase in outgoing NS queries after upgrade to CentOS 6.7?

After upgrading BIND to 9.8.2rc1-RedHat-9.8.2-0.37.rc1.el6_7.2 in a few caching nameservers I've noticed it's doing lots of outgoing NS queries, without changes to incoming traffic volume or patterns. ...