This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @echo off | |
| pushd "%~dp0" | |
| dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~3*.mum >List.txt | |
| dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientTools-Package~3*.mum >>List.txt | |
| for /f %%i in ('findstr /i . List.txt 2^>nul') do dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\%%i" | |
| pause | |
gonchik
/ tableau_views_stats.sql
Last active
July 26, 2023 08:31
Tableau - Get stats of usage views, boards
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Statistics of usage views, boards in Tableau | |
| Also, you can find data in the /var/opt/tableau/tableau_server/data/tabsvc/logs/vizqlserver/vizqlserver_node*.log | |
| */ | |
| SELECT views_stats.user_id AS users_id, | |
| system_users.name AS system_users_name, | |
| users.login_at AS users_login_at, | |
| system_users.friendly_name AS system_users_friendly_name, | |
| views_stats.view_id AS views_id, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # ## installation | |
| # dnf install iproute-tc | |
| # yum install iperf3 # for testing | |
| # tc uses the following units when passed as a parameter. | |
| # kbps: Kilobytes per second | |
| # mbps: Megabytes per second | |
| # kbit: Kilobits per second | |
| # mbit: Megabits per second |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Metabase. Stats | |
| Most viewed questions in the last 3 months | |
| */ | |
| SELECT rc.name AS CardName , COUNT(vl.user_id) AS viewCount | |
| FROM view_log vl | |
| INNER JOIN report_card rc ON rc.id = vl.model_id |
gonchik
/ gist:46b7ff6ba7ffc49fdb5d73376e6e5b0f
Created
January 16, 2022 17:51
just yet another nginx.conf from test env
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| events { | |
| worker_connections 1024; | |
| multi_accept on; | |
| } | |
| http { | |
| proxy_buffering on; | |
| proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=jira_static:20m inactive=60m use_temp_path=off; | |
| proxy_cache_valid any 8h; | |
| sendfile on; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash -eux | |
| # Function to detect the operating system | |
| get_os() { | |
| if [[ -e /etc/debian_version ]]; then | |
| echo "debian" | |
| elif [[ -e /etc/redhat-release ]]; then | |
| echo "redhat" | |
| else | |
| echo "unsupported" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* This script works without notification and history and as a service */ | |
| import com.atlassian.jira.component.ComponentAccessor | |
| import com.atlassian.jira.issue.CustomFieldManager | |
| import com.atlassian.jira.issue.fields.CustomField | |
| import com.atlassian.jira.issue.IssueManager | |
| import com.atlassian.jira.issue.Issue | |
| import com.atlassian.jira.issue.MutableIssue | |
| import org.apache.log4j.Logger | |
| import org.apache.log4j.Level |
gonchik
/ gist:1efdcff188130abbd1fd9281600cb90e
Created
January 22, 2021 15:07
clean_windows_temp_files.bat
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| erase "%TEMP%\*.*" /f /s /q | |
| for /D %%i in ("%TEMP%\*") do RD /S /Q "%%i" | |
| erase "%TMP%\*.*" /f /s /q | |
| for /D %%i in ("%TMP%\*") do RD /S /Q "%%i" | |
| erase "%ALLUSERSPROFILE%\TEMP\*.*" /f /s /q | |
| for /D %%i in ("%ALLUSERSPROFILE%\TEMP\*") do RD /S /Q "%%i" | |
| erase "%SystemRoot%\TEMP\*.*" /f /s /q |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!doctype html> | |
| <html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> | |
| <head> | |
| <title> </title> | |
| <!--[if !mso]><!-- --> | |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
| <!--<![endif]--> | |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Active users | |
| // assignee in activeUsers() | |
| import com.atlassian.jira.bc.JiraServiceContextImpl | |
| import com.atlassian.jira.bc.user.search.UserSearchParams | |
| import com.atlassian.jira.bc.user.search.UserSearchService | |
| import com.atlassian.jira.component.ComponentAccessor | |
| import com.atlassian.jira.jql.operand.QueryLiteral | |
| import com.atlassian.jira.jql.query.QueryCreationContext | |
| import com.atlassian.jira.user.ApplicationUser | |
| import com.atlassian.query.clause.TerminalClause |
NewerOlder